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.
Sign-up now and get instant access
ABOUT THE AUTHOR
I am an IT professional with over 20+ years of progressive technical experience with managing, consulting, software development, data integration architecture, data warehousing, and business intelligence development projects. The focus of my work is to work closely with stakeholders to develop architecture frameworks that align with organizational strategy, processes, and IT assets. Specializing in Business Intelligence (BI), Data Warehousing, database architecture, design and implementation, performance tuning and troubleshooting.
Free Trial
On-demand learning
private training
Leave a comment