SSMA Steps to migrate

 Create a new project using the File menu.

    

In the new project dialogue box, enter name  and select migrate to azure sql server.

 

Click on Connect to oracle and enter the credentials.

Click connect.

once the connection is established all the oracles schemas and objects are displayed in the Oracle metadata explorer.               

then Click on Create report.

 

Once the report is created, the HTML report will be opened in a web browser.

 

At this point you can save the project if you want to some offline analysis. choose the SAVE Project from the File menu.

Click on the Azure SQL Database and enter the Credentials.

Window Will Open

Once the connection is success ,all  the objects in sql azure database are metadata explorer

Select the Schema you want to convert in oracle metadata explorer and then click on convert schema.

once the Schema is converted the objects will be listed under the SQL Azure DB.

Save the Script of sql Azure DB For feature offline reference.

Now that the schema is converted to target Azure SQL DB, the same can be committed into the target system.

Right click on the database name then choose Synchronize with Database.

    

Click on the Hide Equal Objects at the top to see only the difference.

Click ok to initiate the synchronizing with database.

after Synchronizing the database now click on actual data from oracle and select the schema name which has to be migrated and migrate data.

 

Give the Credentials of source DB.

    

Give the Credentials of Target DB.

once the Migration is completed window will display like this.

Save Report For your Reference.