Migrating Oracle Databases to SQL Server (OracleToSQL)
Published: April 1, 2016
SQL Server Migration Assistant (SSMA) for Oracle is a comprehensive environment that helps you quickly migrate Oracle databases to SQL Server or Azure SQL DB. By using SSMA for Oracle, you can review database objects and data, assess databases for migration, migrate database objects to SQL Server or Azure SQL DB, and then migrate data to SQL Server or Azure SQL DB. Note that you cannot migrate SYS and SYSTEM Oracle schemas.
To successfully migrate objects and data from Oracle databases to SQL Server or Azure SQL DB, use the following process:
After you create the project, you can set project conversion, migration, and type mapping options. For information about project settings, see Setting Project Options (OracleToSQL). For information about how to customize data type mappings, see Mapping Oracle and SQL Server Data Types (OracleToSQL).
Optionally, Create assessment reports to assess database objects for conversion and estimate the conversion time.
You can do this in one of the following ways:
Save a script and run it in SQL Server.
Synchronize the database objects.
If necessary, update database applications.