Tell me more ×
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.
up vote 1 down vote favorite

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 at 10:45
@Mat - approx 200 working tables, largest table has millions of records – Shaul Mar 13 at 11:09

1 Answer

up vote 0 down vote

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 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 at 17:00
1  
@RolandoMySQLDBA - I am the OP... – Shaul Mar 13 at 17:06
@Shaul: that is, in fact, irrelevant. Your answer wouldn't really help someone coming to this question through a web search. If you haven't tried it and made it work, this answer isn't of much use. Please consider expanding on it if you do try it. – Mat Mar 13 at 17:25

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.