Migrate SQL Server Database to Azure SQL Database using Data Migration Assistant – part 2

The first two steps can be found at http://georgevwoods.com/2018/08/29/migrate-sql-server-to-azure-sql-server/

Part 3: Migration Assistant

Open the Data Migration Assistant and click on +New to start a new Migration

Choose Migration

Fill in the project name and keep the defaults for the other options and click Create


On the first screen, fill in the Server name and make your choice connection properties and click connect. Reminder the credentials used to connect must have Control Server permission


After connecting, choose the Source database. Keep Assess the database before Migration checked and click next


On the select target screen you have the option to either use an existing server to connect to and choose the target database or you can click on Create a new Azure SQL Database, which will take you to the Azure portal to create the new database.

I went out to the Azure portal and created a new server and database for the migration. I then came back in to the DMA window and filled out the info requested and clicked connect. I am also using SQL Server Authentication to connect.


Choose the database that is the target and click next


Select the objects you want to migrate

Check the Assessment and determine if you can fix the issue or uncheck the issue if you wish to not migrate the blocks


I also had an issue that I could not migrate some of the users, as they were in the form domain\user I just left these unchecked and will manually add any users to the new Azure SQL Server Database


Click generate sql script. This may take a little time to run

Once completed, review the script. When you are satisfied with the script, click deploy schema.


The following screen will appear


On completion, check for errors and determine if you can move on. Once you are satisfied with the schema deploy, click Migrate Data


Check that all of your tables are marked as OK. Also, you can see at the top, that Microsoft strongly recommends that you temporarily change your Azure SQL database to performance level P15during the migration process. This database that I am migrating is so small, that I am going to leave it as is. Click Start data migration


The in-progress screen appears. You can also monitor some of the activity in the Azure portal. For instance, Resource Utilization and used space


Once the data migration has completed you will see at the bottom right that Migration is complete and the Duration


I then connected to the Azure SQL database using SQL Server Management Studio and ran some comparisons to the original source and detected no differences.

Reminder, add any users in to the Azure SQL Server Database that were not automatically migrated.

You have now completed the migration.

 

 

 

Leave a Reply

Your email address will not be published. Required fields are marked *