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. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

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.

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 Behr Mar 13 '13 at 11:09

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 Behr Mar 13 '13 at 17:06

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