Hands-On-Lab: Migrating On-Premise SQL Server Database To Azure SQL Database

Microsoft Azure SQL Database is a DBaaS (Database as a service) or PaaS (Platform as a Service) offering from Microsoft. Azure SQL Database is largely compatible with on premise SQL Server and supports most of the SQL Server features. Azure SQL Database is optimized for SaaS (Software as a Service) applications. In this lab, we’ll learn different ways to effectively migrate on premise SQL Server Database to Azure SQL Database. in the first exercise, we will learn to migrate a database from On-Premise SQL Server to Azure SQL Database using SQL Data-Tier Application (BACPAC) and PowerShell. In the second exercise, we will learn to migrate a database from On-Premise SQL Server to Azure SQL Database using SQL Data-Tier Application (DACPAC), BCP and PowerShell. In the third and final exercise, we will learn to migrate a database from On-Premise SQL Server to Azure SQL Database using SQL Server Migration Wizard.

Exercise 1: Migrate Using SQL Data-Tier Application (BACPAC) and PowerShell
Exercise 2: Migrate Using SQL Data-Tier Application (DACPAC), BCP and PowerShell
Exercise 3: SQL Server Migration Wizard.

SQLMaestros Hands-On-Labs enables the practical way of learning. Each lab document consists of multiple exercises and each exercise consists of multiple tasks. Apart from step-by-step instructions, the HOL document contains images, explanations, observations, notes, tips & tricks to ensure a great learning experience. With each lab, you can practice a specific concept step-by-step. With our HOL documents, you will get hands-on with hundreds of topics in SQL Server & Microsoft Data Platform. Learn More.