Migrating SQL Database On-Prem to Azure SQL Database

Are you looking to modernize your data platform by migrating your on-prem database to Azure? Azure’s Database Migration Assistant is a free, downloadable tool to make this a much simpler process. The Database Migration Assistant provides seamless assessments of SQL Server on premises, as well as upgrades to later versions of SQL Server or migrations to SQL Server on Azure VMs or Azure SQL Database.

The Database Migration Assistant enables you to upgrade to a modern data platform by detecting compatibility issues beforehand, that can impact database functionality on your Azure SQL Database and SQL Server on Azure VMs.

The video demo included with this blog provides a step by step instruction for migrating SQL Server on premise to Azure SQL Database by using the Azure Database Migration Assistant.

I’ll go through each step, including:

• Creating a new migration project
• Specify the source server and database
• Specify the target server and database
• Select the schema and objects
• Deploy the schema
• Data migration

Watch the brief video below for the complete demo of these steps to see how simple it is to migrate your on premise database to a modern data platform. If you have more questions around the Data Migration Assistant or about any Azure product or service, you’re in the right place. Click the link below or contact us—our Azure experts are here to help.