11/12/2018

Using Microsoft Data Migration Assistant

Worked with Microsoft Data Migration Assistant.  Simple and powerful application.

Simply download, open program, Click + for new, selected Migration...





Connect to Source Database...




Select the source database you wish to migrate from the available list...





Had to create an Azure SQL Database destination in Azure Portal to migrate too...




Connect to Destination Database...



Select the objects to migrate...




The database scripts get generated automatically...




Next, execute the scripts...opening the Azure SQL Database from SQL Server Management Studio:



We can see the table got created in Azure SQL Database...




You can store off the scripts for re-use, and you can push the data to Target database from within the application as well.

Nice product offering from Microsoft to Migrate data to and from places.

Thanks for reading~!