2

What would be the easiest way to migrate a database that I have in SQL Server 2005 to Oracle? I have around 6 tables each with a large amount of data in it.

  • 1
    By large, do you mean 10s of Terabytes ? – Gary Mar 7 '11 at 22:19
  • Large is certainly in the eye of the beholder! – DCookie Mar 7 '11 at 23:00
  • around 20 - 30 GB per database – EquinoX Mar 8 '11 at 4:44
4

Have a look at this Oracle page on Migrating Microsoft SQL Server to Oracle.

2

You could try the Database Publishing Wizard from Microsoft. It 'publishes' a database to a T-SQL script. I haven't tried it with migrating to Oracle directly. But, I suspect you could modify with the T-SQL script appropriately.

Database Publishing Wizard link

1

With only six tables, doing a manual conversion will probably get you the best result. Create an ERD, generate the Oracle schema, and then transfer the data by exporting CSV files and importing them. I've used SQL Developer as linked above, but it sometimes takes a bit of work to get everything working, and then you still have to create an ERD for future development. It did save me a lot of time on a conversion but that was over 100 tables. In that case it was faster to use the tool to get most of it created and then go fix everything up.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.