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.
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.
|
|
||||
|
|
marked as duplicate by Jon Seigel, StanleyJohns, Mark Storey-Smith, ypercube, RolandoMySQLDBA May 18 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. http://dbadiary.wordpress.com/2012/10/04/data-migration-from-oracle-to-sql-server-with-ssms/ |
|||
|
|
