DP-3001 Migrate SQL Server workload to Azure SQL

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.

• Explain what data platform modernization is
• Review the stages of a data migration
• Recommend when to use an Azure data platform technology
• Explore the cost savings of moving your SQL workloads to Azure.

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.

• Understand common compatibility issues and blockers that may prevent a migration to Azure SQL.
• Discover the various tools and options available for assessing SQL Server databases for migration purposes.
• Use the Azure migration extension for Azure Data Studio to assess SQL Server databases.
• Use the Azure Migrate and other tools to assess SQL Server databases.

Deploy IaaS solutions with Azure SQL

Configure virtual machine sizing, storage, and networking options to ensure adequate performance for your database workloads. Choose and configure appropriate high availability options.

• Familiarity with on-premises virtualization technologies, including: VMs, virtual networking, and virtual hard disks.
• Familiarity with network configuration, including TCP/IP, Domain Name System (DNS), virtual private networks (VPNs), firewalls, and encryption technologies.
• Ability to create an on-premises SQL Server database, including the configuration of data files and log files.
• Experience creating and configuring resources using the Azure portal.

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.

• Gain an understanding SQL Server in a Platform as a Service (PaaS) offering
• Understand PaaS provisioning and deployment options
• Understand elastic pools
• Examine Azure SQL Managed Instances
• Explore Azure SQL Edge
• Configure a template for PaaS deployment.

Migrate SQL Server workloads to Azure Virtual Machine

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

• Understand the importance of careful planning for a successful migration of SQL Server workloads to Azure Virtual Machines.
• Migrate databases using Azure SQL Migration extension for Azure Data Studio and tracking database migration activities to SQL Server on Azure Virtual Machines.
• Explore several other methods for migrating SQL Server databases to Azure Virtual Machines.

Migrate SQL Server workloads to Azure SQL Database

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

• 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.

Migrate SQL Server workloads to Azure SQL Managed Instance

You’ll explore different migration tools and migrate SQL Server databases to Azure SQL Managed Instance.

• Explore the advantages, capabilities, and migration possibilities offered by Azure SQL Managed Instance.
• Learn how Log Replay Service works to migrate to Azure SQL Managed Instance.
• Understand how Managed Instance link feature works in a migration scenario.
• Load and move data to and from Azure SQL Managed Instance.
• Explore several other methods for migrating SQL Server databases to Azure SQL Database.

Perform post-migration tasks on Azure SQL

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

• Ability to navigate the Azure portal.
• Understanding of the traditional Database Administration role.
• Experience with T-SQL programming language at a basic level.

Assessment test