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

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

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

Hello Friends,

Here is another popular lab from Hands-On-Lab library: 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.



Learn More
 

 
Happy Learning – The Practical Way.



Data Platform Virtual Summit 2020

Subscribe to SQLMaestros YouTube channel. If you want more learning content in your inbox, subscribe to SQLMaestros Bulletin.

SQLMaestros YouTube | SQLMaestros Bulletin | SQLMaestros Twitter

By |2020-09-14T12:44:27+05:30September 14th, 2020|HOLs|0 Comments

About the Author:

Leave A Comment