Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I've got an Oracle database that I need to export (schema and data) to SQL Server.

I am trying the Microsoft SQL Server Migration Assistant for Oracle, but it is horribly slow, grossly inefficient and very un-user-friendly, e.g. I was having problems connecting to the SQL Server DB during data migration - but it still spent ~5 minutes preparing all the data before attempting a connection to SQL Server, then when it failed, the 5 minutes of preparatory work were wasted.

Right now, I'm just trying to connect to another Oracle DB using this tool, I left it overnight and came back this morning, and it's still stuck on 19% of "Loading objects..." And this is on a machine with a good 18GB RAM, of which maybe 8.5 GB currently in use. Task Manager shows me that SSMAforOracle.exe is using 0 CPU, 0 PF Delta, and no change whatsoever in memory usage. In other words: frozen stiff. Absolutely intolerable.

Are there any other tools out there that can migrate an Oracle DB to SQL Server a little more efficiently?

share|improve this question
What sort of size and complexity is your source database? –  Mat Mar 13 '13 at 10:45
@Mat - approx 200 working tables, largest table has millions of records –  Shaul Mar 13 '13 at 11:09
add comment

closed as off-topic by Mat, Mark Storey-Smith, Jon Seigel, RolandoMySQLDBA, dezso Aug 12 '13 at 7:37

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Shopping list question - questions about which tool, library, product or resource you should use are off-topic here because they quickly become obsolete and often are just about the preferences of the answerer. If you have an issue with or a question about a specific tool, please revise your question to conform to that scope." – Mat, Mark Storey-Smith, Jon Seigel, RolandoMySQLDBA, dezso
If this question can be reworded to fit the rules in the help center, please edit the question.

1 Answer

Found Navicat - this looks pretty good.

share|improve this answer
This does not provide an answer to the question. To critique or request clarification from an author, leave a comment below their post. –  RolandoMySQLDBA Mar 13 '13 at 16:44
If Navicat does in fact allow exporting an Oracle database to SQL Server, it would help to note the steps required to do so instead of pointing the OP at a management product website. –  Max Vernon Mar 13 '13 at 17:00
@RolandoMySQLDBA - I am the OP... –  Shaul Mar 13 '13 at 17:06
add comment

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