From Oracle

In this guide, you learn how to migrate your Oracle databases to SQL Server by using SQL

Server Migration Assistant for Oracle (SSMA for Oracle).

For other migration guides, see

Azure Database Migration Guides.

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

Before you begin migrating your Oracle database to SQL Server, perform the following steps:

Verify that your source environment is supported.

Download and install.

Download and install

SSMA for Oracle.

Get the

necessary permissions for SSMA for Oracle

and

provider.

Get connectivity and sufficient permissions to access both source and target.

As you prepare for migrating to the cloud, verify that your source environment is supported

and that you meet all other prerequisites. Doing so helps to ensure an efficient and successful

migration.

This part of the process involves conducting an inventory of the databases that you need to

migrate, assessing them for potential migration issues or blockers, and then resolving any

items you might have uncovered.

To better understand and plan for the migration, use the

Microsoft Assessment and Planning

(MAP) Toolkit

to identify existing data sources and details about the features your

organization is using. This process involves scanning the network to identify all your

organization’s Oracle instances, versions, and features.

To use the MAP Toolkit to perform an inventory scan, perform the following steps:

1. Open the

MAP Toolkit.