Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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.

share|improve this question
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

3 Answers 3

up vote 4 down vote accepted

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

share|improve this answer

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.

share|improve this answer

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

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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