Re: Oracle & MS SQL server - Similarities and differences

"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.

yes. but they mean entirely different things!

A SQL Server instance corresponds to an installation of the SQL server software (AIUI).
An Oracle instance is the set of processes (and memory structures) that manage an oracle database. It is not necessary to reinstall Oracle to get a second instance.

>
> 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.

Oracle only has one transaction log mechanism per database. Other than that that looks like a reasonable comparison. (I think of sqlserver filegroups as tablespaces, but that isn't exact either).

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

With the exception for the source code to procedures yes this is correct.
>
> Is there a place where I can migrate from SQL 2000 and Oracle with
> respect to the concepts. :-)

Oracle produce a handy manual called the Oracle Concepts Guide, it (and the other manuals) are available at http://tahiti.oracle.com.

There are a number of helpful websites

The co-operative faq for these groups at http://www.jlcomp.demon.co.uk/faq/ind_faq.html

Steve Adams site
www.ixora.com.au
> Regards
>
> zrb
Received on Mon Sep 02 2002 - 10:40:57 CDT