Skip to content

Latest commit

 

History

History
43 lines (35 loc) · 3.61 KB

sql-server-migration-assistant-for-oracle-oracletosql.md

File metadata and controls

43 lines (35 loc) · 3.61 KB
Raw
title description author ms.author ms.reviewer ms.date ms.service ms.subservice ms.topic ms.custom f1_keywords
SQL Server Migration Assistant for Oracle (OracleToSQL)
Learn about SSMA for Oracle and follow step-by-step instructions for migrating Oracle databases to SQL Server.
cpichuka
cpichuka
randolphwest
07/10/2023
sql
ssma
conceptual
sql-migration-content
ssma.oracle.general.f1

SQL Server Migration Assistant for Oracle (OracleToSQL)

[!INCLUDE msCoName] [!INCLUDE ssNoVersion] Migration Assistant (SSMA) for Oracle is a tool for migrating Oracle databases to [!INCLUDE sssql11-md] through [!INCLUDE sssql22-md] on Windows and Linux, or [!INCLUDE ssazure-sqldb]. SSMA for Oracle converts Oracle database objects to [!INCLUDE ssNoVersion] or Azure SQL objects, loads those objects into [!INCLUDE ssNoVersion] or Azure SQL, and then migrates data from Oracle to [!INCLUDE ssNoVersion] or Azure SQL.

This documentation introduces you to SSMA for Oracle and provides step-by-step instructions for migrating Oracle databases to [!INCLUDE ssNoVersion]. The following table shows articles to help you learn more:

Database Migration Assessment for Oracle extension

Try the Database Migration Assessment for Oracle extension in Azure Data Studio for Oracle to SQL pre-assessment and workload categorization. This extension is useful if you are:

  • in the early phase of Oracle to SQL migration and need to do a high level workload assessment
  • interested in sizing an Azure SQL target for your Oracle workload
  • looking to understand feature migration parity

For detailed code assessment and conversion, continue with SSMA for Oracle.

Contents

Section Description
What's New in SSMA for Oracle What's 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 [!INCLUDE ssNoVersion].
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.