Re: Oracle & MS SQL server - Similarities and differences

Your best bet would be Oracle Concepts manual followed by some good reading from Oracle experts (Thomas Kyte's book is among highly recommended as it has very good insights on key differences between Oracle and other databases). Actually difference (or similarity) between MSSQL's 'database' and Oracle's 'schema' concepts is negligible compared to the differences in transaction mechanisms, concurrency controls and locking mechanisms in Oracle and other databases. Oracle is very different in the way it works, and to successfully develop for it you should understand the difference. Signup to Oracle Technology Network at http://otn.oracle.com (it's free) and you'll get instant access to Oracle online documentation among other stuff.

Corrections and additions welcome.

--
Vladimir Zakharychev (bob@dpsp-yes.com)                http://www.dpsp-yes.com
Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications.
All opinions are mine and do not necessarily go in line with those of my employer.


"zrb" <zrajbun_at_hotmail.com> wrote in message news:2312ee51.0209020448.62f6da46_at_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