Import data from SQL Server 2000 into Oracle 9i

[JtheRipper]

Hi there,

I have a spanking new oracle 9i database, now I need to import a database (all objects and data) from SQL Server 2000 into my oracle 9i database. I probably need to go and create all the objects manually, but what worries me most is how to get the data to Oracle. Can I do this from oracle to "pull" the data or should I rather try and use SQL Server DTS to "push" the data to the oracle database? What about data types? Programmatic code like triggers and procedures also probably need to be rewritten?

Does anyone have any ideas on how to make this is painless as possible?

Thanks

 

[JtheRipper]

Ok, got the answer. For those interested you have to use the Oracle Migration Workbench which is free to download from

http://www.otn.oracle.com