Migrate Oracle to SQL Server 2000

[JtheRipper]

Hi there,

I want to know if anyone knows of a tool/application that can migrate an oracle database (8i/9i) to SQL Server 2000? I know that the Oracle Migration Workbench migrates SQL Server to Oracle, but I want the opposite.

Any help will be greatly appreciated.

Thanks,
J.

P.S. I will also post this in the Oracle forum.

 

[paul172]

You can use the DTS wizard to connect to an oracle DB and pull accross tables/views/stored procs etc.

 

[JtheRipper]

Hi,

Thanks for the feedback. What do I use in DTS to pull the stored procs, etc across? Do I need to create the tables, etc first in the SQL Server database and just use a normal data pump or is there a way that the tables, etc can be created on SQL server automatically?

Thanks
J.

 

[paul172]

You can either create a new database before you run the wizard or you can create a new database as part of the wizard. Just give it a try, you won't break anything, it's pretty easy to use really!

 

[SQLSister]

You can script the stored procedures and then run them in Query analyzer, but be aware that many if not most will need to be rewritten as T-SQL and PL/SQL do not have the same syntax.

Questions about posting. See faq183-874