Migrate Oracle Database to SQL Server using SQL Server Migration Assistant for Oracle.

Prerequisites:

• Oracle Database 19c
• SQL Server Migration Assistant for Oracle
• SQL Server Developer Tool for Oracle
• SQL Server 2016
• SQL Server Management Studio

Steps to Migrate.

Step 1.

Install and Configure Oracle Database 19c.

Create a sample Database and Table.

Step 2.

Install and Configure SQL Server 2016.

Create a sample Database.

Step 3.

Open SSMA in the source machine.

Create New Project with target SQL Server 2016.

Step 4.

Select the source “Oracle”.

Provide is credentials and select object.

Step 5.

Select the table you want to migrate.

Step 6.

Click on Create Report.

Step 7.

Click on Target “SQL Server”.

Provide its Credentials

Step 8.

Go to the database where you want to migrate the data.

Select the database of source and click on “Convert Schema”.

Step 9.

Select the target database, then go to tools and click on “Synchronise the Database”.

Click on “OK”.

Step 10.

Go to Target machine, Login to server and check the data in the table.

Enter the Source and Target Credentials.

Step 11.

Database successfully migrated.

Errors

Error 1

There are no Errors but 2 warnings stating that we need to change the datatype if we want from Oracle to SQL

Workaround

We can solve the Error by changing the data type mapping

Error 2

This happens when we log in with the user with not enough rights to execute that schema.

Workaround

We must log in with the system and SYS if possible, most of the time.