Oracle & MS SQL server - Similarities and differences

From: zrb <zrajbun_at_hotmail.com>
Date: 2 Sep 2002 05:48:18 -0700
Message-ID: <2312ee51.0209020448.62f6da46@posting.google.com>

Hi,

I have been using MS SQL 2000 server for quite some time. Now I am working on porting the application to Oracle 8i. I am looking for the similarities and differences between the two. Like the following.

MS SQL 2000 and Oracle both have the concept of instances.

In SQL 2000 a database specifies a logical as well as physical unit of storage, transactions etc. And the best equivalent from Oracle seems to be a "schema + tablespace". But am I right about the transaction context part of my statement.

In SQL 2000 tables, views, indexes, procedures etc exist within a database whereas in Oracle they exist within a schema.

Is there a place where I can migrate from SQL 2000 and Oracle with respect to the concepts. :-)

Regards

zrb Received on Mon Sep 02 2002 - 07:48:18 CDT