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.

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

3 Answers 3

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.

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .