SQL Server Migration Assistant for Oracle (OracleToSQL)
Microsoft SQL Server Migration Assistant (SSMA) for Oracle is a tool for migrating Oracle databases to Microsoft SQL Server 2012, Microsoft SQL Server 2014, Microsoft SQL Server 2016, Microsoft SQL Server 2017 on Windows and Linux, Microsoft SQL Server 2019 on Windows and Linux, and Azure SQL Database. SSMA for Oracle converts Oracle database objects to SQL Server database objects, creates those objects in SQL Server, and then migrates data from Oracle to SQL Server.
This documentation introduces you to SSMA for Oracle and provides step-by-step instructions for migrating Oracle databases to SQL Server. The following table shows articles to help you learn more:
Note
Try new Database Migration Assessment for Oracle extension in Azure Data Studio for Oracle to SQL pre-assessment and workload categorization. If you are in early phase of Oracle to SQL migration and would need to do a high level workload assessment , interested in sizing Azure SQL target for the Oracle workload or understand feature migration parity, try the new extension. For detailed code assessment and conversion, continue with SSMA for Oracle.
Contents
| Section | Description |
|---|---|
| What's New in SSMA for Oracle | What is new in this version of SSMA for Oracle |
| Installing SSMA for Oracle (OracleToSQL) | Contains articles that provide prerequisites and instructions for installing the SSMA for Oracle client and required components on the computer that is running SQL Server. |
| Getting Started with SSMA for Oracle (OracleToSQL) | Introduces the user interface, projects, and configuration options. |
| Migrating Oracle Databases to SQL Server (OracleToSQL) | Provides an overview of the conversion process and detailed information about each step in the process. |
| Migration guide: Oracle to Azure SQL Managed Instance | This guide teaches you to migrate your Oracle schemas to Azure SQL Managed Instance by using SQL Server Migration Assistant for Oracle. |
| User Interface Reference (OracleToSQL) | Contains documentation for SSMA for Oracle dialog boxes. |
| Working with SSMA for Oracle Console | Contains documentation on the SSMA Console application |
| Getting SSMA for Oracle Assistance | Provides information about getting additional assistance. |