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.

Subscribe to Download


Version1.0
Download2
File Size1.27 MB
Create DateApril 11, 2017
Last UpdatedApril 11, 2017
Predicting DiamondRates with Azure ML
Securing Azure SQL Databases