Re: Oracle & MS SQL server - Similarities and differences

Hi,

  I am more interested in the similarities & differences with respect to transactions from a Distributed Transactions perspective. Any hints.

Thanks in advance

zrb

zrajbun_at_hotmail.com (zrb) 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
Received on Tue Sep 03 2002 - 01:18:08 CDT