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 step by step instructions 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.
Need further help? Our expert team and solution offerings can help your business with any Azure product or service, including Managed Services offerings. Contact us at 888-8AZURE or [email protected].