Oracle 10 to MSSQL 2012 Server

What you’ll need:

• Source: Oracle 10 DB server (pre-existing is fine)
• Target: A SQL Server 2012 (pre-existing might be fine, depends on what you are transferring to it exactly)
• Oracle Database 11g Release 2 Client (11.2.0.1.0) for Microsoft Windows (32-bit) (win32_11gR2_client)
• Microsoft SQL Server Migration Assistant v5.3 for Oracle
  • Includes:
  • SSMA_Oracle\SSMA for Oracle.5.3.0.exe
  • SSMA_Oracle\SSMA for Oracle.5.3.0.ExtPack.exe

After installing the tools, open the SqlMigration3 32 bit version from Window’s start menu
Start->All Programs->Microsoft SQL Server Migration Assistant for Oracle->Microsoft SQL Server Migration Assistant for Oracle (32-bit)

*Note: Do not use the desktop shortcut, it is likely the 64 bit version which will not work with our 32 bit client.

Steps (After opening SqlMigration3 (32-bit)…):

1. Create a new project: File->”New Project…”
   • 
   • 
     (Any save location is fine)
2. Connect to your SQL Server
   • 
3. Connect to your Oracle DB
   • 
4. Select the schema from the Oracle’s list and checkbox all of the components you wish to transfer.
5. HIGHLIGHT the most upper item in the tree expanded list and click the “Convert Schema” button
6. (Optional?) Next click Migrate Data? (Not sure if this is even necessary)
7. Once the transfer is complete…
   1. Right click on the SQL Server schema and select the menu option of “Synchronize With Database”
      1. 
         (This will take our “working area” data and actually transfer/sync it with our live SQL Server database)
   2. That’s it.
8. You’re done!