title
Please take a moment to fill out this form. We will get back to you as soon as possible.
All fields marked with an asterisk (*) are mandatory.
Migrate SQL Server workloads to Azure SQL Database
Duration
1
Course
MOC-DP-3001
Available Formats
Classroom Training, Online Training
Course Description
Overview
This learning path prepares you for the task of migrating SQL Server workloads to Azure SQL.Student will learn how to assess SQL Server components and compatibility for migration using the Azure SQL Migration Extension and Database Migration Assistant. They will also learn how to provision and configure Azure SQL resources. Students will gain hands-on experience in choosing the best migration option to meet business requirements for downtime, handling migration state, and monitoring database migration.
Additionally, students will also learn to perform post-migration tasks like disaster recovery and monitoring. These skills are essential for ensuring a smooth, efficient transition to Azure SQL, and maintaining its operation post-migration.
Students need an Azure subscription to complete the exercises. If you don't have an Azure subscription, create a free account and add a subscription before you begin. https://azure.microsoft.com/en-us/pricing/purchase-options/azure-account?cid=msft_learn
This module is part of these learning paths:
- Architect a data platform in Azure
- Migrate application workloads and data to Azure
- Migrate ASP.NET Apps to Azure
- Migrate SQL Server workloads to Azure SQL
- Plan and implement data platform resources
- Work with relational data in Azure
Objectives
In this module, you will:
- 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 the Data Migration Assistant (DMA) tool to facilitate SQL Server migrations to Azure SQL Database.
- 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.
Audience
- Administrator
- Data Engineer
- Database Administrator
- Developer
- Solution Architect
Prerequisites
- Experience with SQL Server databases.
- Knowledge of SQL Server editions and versions.
- Basic knowledge of security concepts like identities and permissions.
- Experience using the Azure portal to create resources and set permissions.
Topics
Design a SQL Server migration strategy
- Introduction
- Examine data platform modernization
- Plan a data migration
- Explore the available data migration technologies
- Exercise: Compare on-premises Azure costs
- Module assessment
- Introduction
- Review database for compatibility
- Explore assessment options for database migration
- Assess a database with Azure Migration extension
- Assess a database with Azure Migrate
- Exercise: Identify compatibility issues
- Module assessment
- Introduction
- Explain IaaS options to deploy SQL Server in Azure
- Understand hybrid scenarios
- Explore performance and security
- Explain high availability and disaster recovery options
- Exercise: Provision a SQL Server on an Azure Virtual Machine
- Module assessment
- Introduction
- Explain PaaS options for deploying SQL Server in Azure
- Explore single SQL database
- Deploy SQL database elastic pool
- Understand SQL database hyperscale
- Examine SQL managed instance
- Exercise: Deploy an Azure SQL Database
- Module assessment
- Introduction
- Review migrations strategies and tools
- Explore Azure SQL Migration extension for Azure Data Studio
- Understand distributed availability group for migration
- Migrate databases using native backup and restore
- Compare additional migration methods
- Exercise: Migrate SQL Server databases to SQL Server on Azure Virtual Machine
- Module assessment
- Introduction
- Choose the right Azure SQL Database feature
- Use Azure SQL migration extension to migrate to Azure SQL Database
- Migrate to Azure SQL Database using BACPAC
- Use an online method to migrate to Azure SQL Database
- Move data to Azure SQL Database
- Exercise - Migrate a SQL Server database to Azure SQL Database
- Module assessment
- Introduction
- Evaluate migration scenarios
- Use Log Replay Service (LRS) to migrate
- Migrate using Managed Instance link
- Move data to SQL Managed Instance
- Exercise - Migrate a SQL Server database to Azure SQL Managed Instance
- Module assessment
- Introduction
- Migrate SQL logins and groups
- Implement security to protect Azure SQL
- Implement compliance controls for sensitive data
- Monitor database performance
- Configure high availability and disaster recovery
- Automate database tasks for scalability
- Exercise: Configure geo-replication for Azure SQL Database
- Module assessment
Related Courses
-
Microsoft Azure Security Technologies
MOC-AZ-500T00- Duration: 4 Days
- Delivery Format: Classroom Training, Online Training
- Price: 2,380.00 USD
-
Introduction to Microsoft Azure
MOC-AZ-900T00- Duration: 1 Day
- Delivery Format: Classroom Training, Online Training
- Price: 595.00 USD
Self-Paced Training Info
Learn at your own pace with anytime, anywhere training
- Same in-demand topics as instructor-led public and private classes.
- Standalone learning or supplemental reinforcement.
- e-Learning content varies by course and technology.
- View the Self-Paced version of this outline and what is included in the SPVC course.
- Learn more about e-Learning
Course Added To Shopping Cart
bla
bla
bla
bla
bla
bla
Self-Paced Training Terms & Conditions
??spvc-wbt-warning??
Exam Terms & Conditions
??exam-warning??
??group-training-form-area??
??how-can-we-help-you-area??
??personalized-form-area??
??request-quote-area??
Sorry, there are no classes that meet your criteria.
Please contact us to schedule a class.
STOP! Before You Leave
Save 0% on this course!
Take advantage of our online-only offer & save 0% on any course !
Promo Code skip0 will be applied to your registration
Nothing yet
Purchase Information
??elearning-coursenumber?? ??coursename??
View Cart
title
Please take a moment to fill out this form. We will get back to you as soon as possible.
All fields marked with an asterisk (*) are mandatory.