Re: Difference Between Microsoft SQL and Oracle

From: DA Morgan <damorgan_at_exesolutions.com>
Date: Fri, 17 Jan 2003 13:57:22 -0800
Message-ID: <3E287C42.3216D889@exesolutions.com>

los wrote:

> What is the difference, in a nutshell between these two RDBMS's . Are they
> both for very large databases. Is Oracle more prevelant in the Corporate
> environment?

At the risk of some flame-war imbecility.

SQL Server is limited to a 32bit O/S so by definition can not be scaled as large as Oracle.

It does not match Oracle in many respects many important but also in more mundane ways such as being very limited when it comes to trigger and trigger types.

Both are now prevalent in most corporate and government organizations in the US whereas Oracle is far more dominant outside the US. But in any case Oracle and DB/2 for large mission-critical systems.

In a nutshell ... the concepts are different. The architecture is different. And the more you know about them the more different, rather than the more similar, they are.

Daniel Morgan Received on Fri Jan 17 2003 - 15:57:22 CST