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
Reviews
There are no reviews yet.