SQL Server 2000 db migration to Oracle 9i

[ghosh...@gmail.com]

Hi,

Can anyone let me know of a tool which shall migrate the entire SQL
Server 2000 database to Oracle 9i along with all the stored procedures
. Someone in the net has posted that a tool comes with the Oracle 9i
software .

Any help would be appreciated .

Thanks ,

Sujay

[Jim Kennedy]

<ghosh...@gmail.com> wrote in message
news:1110551038....@g14g2000cwa.googlegroups.com...

You can go to otn.oracle.com and download Oracle's migration workbench. But
stored procedures won't be translated. They are written in different
languages (Transact sql for MS SQL Server and PL/SQL in Oracle) and thus
won't directly translate. In addition, these databases work much
differently so a direct port will suck.

Also I would recommend un quoting all the object names; if you don't you are
going to have a devil of a time.
Jim