Step-by-Step Guide to Running Attunity Replicate for Microsoft Migrations

This document is meant to be used as a Quick Start Guide to migrate schema & data from Oracle to Azure SQL DB using Attunity Replicate for Microsoft Migrations tool.

Steps

Download the tool from http://attunity.com/MicrosoftMigrations and install on your machine

Start Replicate service if it is not already running. You can do this using the Start Replicate for Microsoft Migrations under Attunity Replicate for Microsoft Migrations program option.

Open the web console using Attunity Replicate for Microsoft Migrations Console program under Attunity Replicate for Microsoft Migrations folder. Open the web console in Internet Explorer browser (I ran into issues when tried on Edge or Chrome browser)

Expand the More information section if the browser gives a security warning

Click on Go on to the webpage (not recommended). This will bring up the home page of the tool.

Click on Manage Endpoint Connections button to add connection details of both the source & target databases

Click on + New Endpoint Connection button.

Provide the source connection details. Be sure to select Role as Source and Type as Oracle. Specify the User name and Password. Be sure to provide the Connection string in the below format (other formats did not work when I tried)

(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=xx.xx.xx.xx)(PORT=xxxx))(CONNECT_DATA=(SID=xxxx)))

Click on Test Connection after all the details are provided. Click on Save once the connection test is successful.

Follow the same procedure to add a New Endpoint Connection to provide target connection details. Select Role as Target and Type as Microsoft Azure SQL Database. Specify the connection details, test connection and save the endpoint information.

Once the endpoints are setup, create a new task by clicking on the + New Task button on the top ribbon.

In the New Task dialog box, make sure you choose only Full Load under Task Options. If any other task options are selected (ex: Apply Changes or Store Changes), be sure to un select them by clicking on the option (Blue color indicates selected and grey color indicates not selected). Specify a name for the task and click OK.

The endpoints are shown on the left pane and a diagram is shown to represent the flow. Drag & drop the end points into the appropriate source & target locations on the diagram. (Oracle endpoint to the source location & Azure SQL DB endpoint to the target location).

Once the source & target endpoints are placed, click on the Table Selection button to select the schema & tables from the source to migrate.

In the Select Tables dialog box, select the Schema from the drop down and click on Search button to list all the tables under that schema.

Once the tables under the selected schema are listed, use the >> (add all) button to add all tables in the schema to the migration task. Alternatively, you can also select specific tables and add them to the migration task too.

Click on OK button after all the required tables are selected and added to the migration task.

The source, target and the list of tables selected for the migration task are displayed.

Click on the Run button on the top ribbon to start the migration task

Once the task has started, the view switches to the Monitor tab to display the detailed status of the migration task.

The summary of the migration task is displayed once the task completes.

Once the data migration is complete, connect to the target Azure SQL DB using a different tool like SSMS and query a table to confirm that the data was transferred successfully from Oracle to Azure SQL DB.