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

<ghosh.sujay (AT) gmail (DOT) com> wrote

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