Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

SQL Server 2000 db migration to Oracle 9i

3 views
Skip to first unread message

ghosh...@gmail.com

unread,
Mar 11, 2005, 9:23:58 AM3/11/05
to
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

unread,
Mar 11, 2005, 10:38:37 PM3/11/05
to

<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


0 new messages