Events
Mar 31, 11 PM - Apr 2, 11 PM
The ultimate SQL, Power BI, Fabric, and AI community-led event. March 31 - April 2. Use code MSCUST for a $150 discount. Prices go up Feb 11th.
Register todayThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
SQL Server Migration Assistant (SSMA) for Oracle is a comprehensive environment that helps you quickly migrate Oracle databases to SQL Server, Azure SQL Database, or Azure Synapse Analytics. By using SSMA for Oracle, you can review database objects and data, assess databases for migration, migrate database objects to SQL Server, Azure SQL Database, or Azure Synapse Analytics, and then migrate data to SQL Server, Azure SQL Database, or Azure Synapse Analytics. You can't migrate SYS and SYSTEM Oracle schemas.
For detailed code assessment and conversion, continue with SSMA for Oracle.
To successfully migrate objects and data from Oracle databases to SQL Server, Azure SQL Database, or Azure Synapse Analytics, use the following process:
Work with SSMA Projects (OracleToSQL).
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, Assessing Oracle Schemas for Conversion (OracleToSQL) to assess database objects for conversion and estimate the conversion time.
Loading Converted Database Objects into SQL Server (OracleToSQL).
You have two options:
If necessary, update database applications.
Events
Mar 31, 11 PM - Apr 2, 11 PM
The ultimate SQL, Power BI, Fabric, and AI community-led event. March 31 - April 2. Use code MSCUST for a $150 discount. Prices go up Feb 11th.
Register todayTraining
Module
Migrate Oracle workloads to Oracle Database@Azure - Training
Learn how to migrate your Oracle workloads to Oracle Database@Azure.
Certification
Microsoft Certified: Azure Database Administrator Associate - Certifications
Administer an SQL Server database infrastructure for cloud, on-premises and hybrid relational databases using the Microsoft PaaS relational database offerings.
Documentation
Working with SSMA Projects (OracleToSQL) - SQL Server
Learn how to create an SSMA project that contains metadata for Oracle databases to migrate and SQL Server, along with settings and connection information.
Migrating Oracle Data into SQL Server (OracleToSQL) - SQL Server
Learn how to migrate data from an Oracle database to SQL Server, after you synchronize the converted objects, by using the SSMA for Oracle application.
SQL Server Migration Assistant for Oracle (OracleToSQL) - SQL Server
Learn about SSMA for Oracle and follow step-by-step instructions for migrating Oracle databases to SQL Server.