Opi kuinka teet migraatiot SQL Serveristä Azureen.
Tavoite
Tällä Microsoft Applied Skills koulutuksella on tavoitteena on oppia eri SQL Serverin migraatiotapojen toteutus Azureen. Kurssin lopussa suoritetaan Applied Skills Assessment, jolla voi osoittaa osaamisensa.
Kenelle
Koulutus on suunnattu SQL Server -asiantuntijoille.
Koulutuksen sisältö
Assess and prepare databases for migration
- Install and run Azure SQL Migration extension for Azure Data Studio
- Identify and resolve issues that will block migration
- Identify and resolve compatibility issues
- Choose the correct purchasing model for an Azure SQL Database based on requirements
Provision and configure an Azure SQL Database
- Specify the database name
- Create an Azure SQL server
- Configure compute and storage
- Select a backup storage redundancy option
- Configure a private endpoint
- Select database collation
- Configure an Microsoft Entra ID admin account
Migrate a database to an Azure SQL Database
- Migrate a database
- Migrate set of tables
Configure disaster recovery
- Configure active geo-replication
- Select the correct server
- Set up user access to the secondary database
- Failover to a different region
Perform post-migration configuration
- Enable long-term backup support
- Configure health alerts
- Create alert rules for space used and CPU
- Enable and configure Azure SQL Auditing
Migrate instance-level dependencies
- Migrate users
- Migrate logins
Avainsanat
SQL Server, Azure SQL, Migraatiot