DP-3001 - Migrate SQL Server workloads to Azure SQL Database

You will explore different migration tools and migrate SQL Server databases to Azure SQL Database.

Duration: 1.0

Enquire Now

Start learning today!

Click Hereto customize your Training

Objectives

  • Explore the advantages, capabilities, and migration possibilities offered by Azure SQL Database.
  • Migrate databases using Azure SQL Migration extension for Azure Data Studio and tracking database migration activities.
  • Use transactional replication as an online method to migrate to Azure SQL Database.
  • Explore several other methods for migrating SQL Server databases to Azure SQL Database.

Content

1. Design a SQL Server migration strategy

In this module, you'll learn the phases of a migration and the steps involved to ensure your migration project is executed smoothly. You'll also learn the purpose of data platform modernization and see the benefits it can bring to your organization.

Click here to know more

2. Assess SQL Server databases for migration to Azure SQL

Assessment tools such as Azure SQL Migration extension for Azure Data Studio, Azure Migrate, and Data Migration Assistant facilitate the migration of SQL Server databases to Azure.

Click here to know more

3. Deploy PaaS solutions with Azure SQL

Provision and deploy Azure SQL Database and Azure SQL managed instance. Select the appropriate options when performing a migration to the SQL PaaS platform.

Click here to know more

4. Configure database authentication and authorization

Contrast authentication using Microsoft Entra ID, Windows Active Directory, and SQL Server authentication. Implement various security principals and configure permissions.

Click here to know more

5. Migrate SQL Server workloads to Azure SQL Database

You will explore different migration tools and migrate SQL Server databases to Azure SQL Database.

Click here to know more

6. Perform post-migration tasks on Azure SQL

You'll explore different features and tools to help you maintain Azure SQL environments.

Click here to know more

Audience

N/A

Prerequisites

  • Experience in administering SQL Server databases.
  • Knowledge of SQL Server editions and versions.
  • Knowledge of basic T-SQL.

Certification

product-certification

Course Benefits

product-benefits
  • Career growth
  • Broad Career opportunities
  • Worldwide recognition from leaders
  • Up-to Date technical skills
  • Popular Certification Badges

Microsoft Popular Courses

ms-700t00

The Managing Microsoft Teams course is designed for those aspiring to be Microsoft 365 Teams Administrators to deploy, configure and manage Office 365 workloads

az-900t00

This course is a high-level overview of Azure. The course will provide foundational level knowledge of cloud services and how those services are provided with M

sc-900t00

This course provides foundational level knowledge on security, compliance, and identity concepts and related cloud-based Microsoft solutions.

mb-335t00

MB-335T00 is a course code that refers to a specific training program or course offered by Microsoft. Unfortunately, as of my knowledge cutoff in September 2021
Enquire Now
 
 
 
 
OlwQk2
By clicking "Submit", I agree to the Terms Of Use and Privacy Policy