Migrating On-Premise SQL Server Database To Azure SQL Database

Home/Azure SQL Database/Migrating On-Premise SQL Server Database To Azure SQL Database

Migrating On-Premise SQL Server Database To Azure SQL Database

$15.00 $4.00

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

Category:

Description

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

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

Reviews

There are no reviews yet.

Only logged in customers who have purchased this product may leave a review.