- Design a SQL Server migration strategy
By the end of this module, you'll be able to:
- 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
- Learn multiple assessment tools that facilitate the migration of databases to Azure, including SQL Server enabled by Azure Arc, Azure Migrate, and Azure Database Migration Service.
In this module, you'll:
- 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 SQL Server enabled by Azure Arc to assess SQL Server instances.
- Use Azure Migrate to assess SQL Server databases at scale.
- Deploy IaaS solutions with Azure SQL
After completing this module, you will be able to:
Explore the basics of SQL Server in an Infrastructure as a Service (IaaS) offering
Learn the available options for provisioning and deployment
Deploy SQL Server into an Azure Virtual Machine
- Deploy PaaS solutions with Azure SQL
After completing this module, you will be able to:
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
Configure a template for PaaS deployment
- Discover the tools and features available to migrate SQL workloads from on-premises to Azure Virtual Machines (VMs).
In this module, you'll:
- Understand the importance of careful planning for a successful migration of SQL Server workloads to Azure Virtual Machines.
- Explore several methods for migrating SQL Server databases to Azure Virtual Machines.
- Learn the essentials of Azure SQL Database deployment and migration. Explore its benefits, exclusive features, and migration options while optimizing performance and application connections for a smooth transition to the cloud.
In this module, you'll:
Explore the advantages, capabilities, and migration possibilities offered by Azure SQL Database.
Migrate databases using Azure Database Migration Service with Azure CLI 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
In this module, you'll:
- 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.
- Learn post-migration tasks and the tools available to configure automation, high availability and disaster recovery, and monitoring.
At the end of this module, you'll be able to:
- Implement compliance controls for sensitive data.
- Monitor database performance in Azure SQL.
- Configure high availability and disaster recovery in Azure SQL.
- Automate database tasks for scalability.
