SQL Server Migration Assistant for Oracle (OracleToSQL)
SQL Server Migration Assistant (SSMA) for Oracle is a tool for migrating Oracle databases to SQL Server 2012 (11.x) through SQL Server 2022 (16.x) on Windows and Linux, or Azure SQL Database. SSMA for Oracle converts Oracle database objects to SQL Server or Azure SQL objects, loads those objects into SQL Server or Azure SQL, and then migrates data from Oracle to SQL Server or Azure SQL.
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:
For detailed code assessment and conversion, continue with SSMA for Oracle.
Contents
| Article | Description |
|---|---|
| What's new in SSMA for Oracle (OracleToSQL) | Describes what's new in this version of SSMA for Oracle. |
| Install 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. |
| Explore SSMA for Oracle interface | Introduces the user interface, projects, and configuration options. |
| Migrate 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 (OracleToSQL) | Contains documentation on the SSMA Console application. |
| SQL Server Migration Assistant | Provides information about getting more assistance. |