Re: Migrating an Application from SQL Server 2000 to Oracle 10g

> I just completed a review of a massive amount of SQL Server 2008
> docs and have an installed copy of the product that I am using
> to create a similar mapping page for the newest version. But,
> again, I see nothing like autonomous transactions, exception_init,
> serially reusable, or inline in the product.

BTW Daniel there is one thing with your excellent comparison paper - SQL Server 2005 of course doesn't have Hierarchical queries in form of start with ..connect by, but recursive queries can be performed using common table expressions (in oracle world these are called subquery factoring or WITH clause). So in general recursive queries are available also in SQL Server just with different mechanism. And I've also looked a bit in SQL Server 2008. It has quite nice Merge statement wich it seems works smarter than Oracle Merge (for example does only delete and not at first update and then delete).

Gints Plivna
http://www.gplivna.eu Received on Thu Jul 17 2008 - 14:06:27 CDT