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

This question already has an answer here:

If you need to do a data migration from an Oracle database to SQL server, what approaches and technical solutions are the best practice?

Our database has about 100 million rows and a total of 52 tables.

share|improve this question

marked as duplicate by Jon Seigel, StanleyJohns, Mark Storey-Smith, ypercubeᵀᴹ, RolandoMySQLDBA May 18 '13 at 20:39

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

You can do this directly from SQL Server Management Studio. Within SSMS, just right click the database, select Tasks -> Import Data, select an Oracle typed data source and set up your connection to the Oracle database.

Here's a really good description of the full procedure, including setting up an Oracle client on the machine doing the migration.

share|improve this answer

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