Learn how to perform online and offline SQL Server migrations to Azure SQL
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.
Course Outline
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
- Summary
Assess SQL Server databases for migration to Azure SQL
- Introduction
- Review database for compatibility
- Explore assessment options for database migration
- Assess SQL Server with Azure Arc
- Assess a database with Azure Migrate
- Exercise: Identify compatibility issues
- Module assessment
- Summary
Deploy IaaS solutions with Azure SQL
- 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
- Summary
Deploy PaaS solutions with Azure SQL
- 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
- Summary
Migrate SQL Server workloads to Azure Virtual Machine
- Introduction
- Review migrations strategies and tools
- 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
- Summary
Migrate SQL Server workloads to Azure SQL Database
- Introduction
- Choose the right Azure SQL Database feature
- Use Azure Database Migration Service 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
- Summary
Migrate SQL Server workloads to Azure SQL Managed Instance
- Introduction
- Evaluate migration scenarios
- Migrate using Azure Arc
- 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
- Summary
Perform post-migration tasks on Azure SQL
- 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
- Summary
