{"course":{"productid":34137,"modality":1,"active":true,"language":"fr","title":"Migrate SQL Server workloads to Azure SQL","productcode":"DP-3001","vendorcode":"MS","vendorname":"Microsoft","fullproductcode":"MS-DP-3001","courseware":{"has_ekit":true,"has_printkit":false,"language":""},"url":"https:\/\/portal.flane.ch\/course\/microsoft-dp-3001","essentials":"<ul>\n<li>Experience with SQL Server databases.<\/li><li>Knowledge of SQL Server editions and versions.<\/li><li>Basic knowledge of security concepts like identities and permissions.<\/li><li>Experience using the Azure portal to create resources and set permissions.<\/li><\/ul>","contents":"<h4>Design a SQL Server migration strategy<\/h4><ul>\n<li>Introduction<\/li><li>Examine data platform modernization<\/li><li>Plan a data migration<\/li><li>Explore the available data migration technologies<\/li><li>Exercise: Compare on-premises Azure costs<\/li><li>Module assessment<\/li><li>Summary<\/li><\/ul>\n<h4>Assess SQL Server databases for migration to Azure SQL<\/h4><ul>\n<li>Introduction<\/li><li>Review database for compatibility<\/li><li>Explore assessment options for database migration<\/li><li>Assess SQL Server with Azure Arc<\/li><li>Assess a database with Azure Migrate<\/li><li>Exercise: Identify compatibility issues<\/li><li>Module assessment<\/li><li>Summary<\/li><\/ul>\n<h4>Deploy IaaS solutions with Azure SQL<\/h4><ul>\n<li>Introduction<\/li><li>Explain IaaS options to deploy SQL Server in Azure<\/li><li>Understand hybrid scenarios<\/li><li>Explore performance and security<\/li><li>Explain high availability and disaster recovery options<\/li><li>Exercise: Provision a SQL Server on an Azure Virtual Machine<\/li><li>Module assessment<\/li><li>Summary<\/li><\/ul>\n<h4>Deploy PaaS solutions with Azure SQL<\/h4><ul>\n<li>Introduction<\/li><li>Explain PaaS options for deploying SQL Server in Azure<\/li><li>Explore single SQL database<\/li><li>Deploy SQL database elastic pool<\/li><li>Understand SQL database hyperscale<\/li><li>Examine SQL managed instance<\/li><li>Exercise: Deploy an Azure SQL Database<\/li><li>Module assessment<\/li><li>Summary<\/li><\/ul>\n<h4>Migrate SQL Server workloads to Azure Virtual Machine<\/h4><ul>\n<li>Introduction<\/li><li>Review migrations strategies and tools<\/li><li>Understand distributed availability group for migration<\/li><li>Migrate databases using native backup and restore<\/li><li>Compare additional migration methods<\/li><li>Exercise: Migrate SQL Server databases to SQL Server on Azure Virtual Machine<\/li><li>Module assessment<\/li><li>Summary<\/li><\/ul>\n<h4>Migrate SQL Server workloads to Azure SQL Database<\/h4><ul>\n<li>Introduction<\/li><li>Choose the right Azure SQL Database feature<\/li><li>Use Azure Database Migration Service to migrate to Azure SQL Database<\/li><li>Migrate to Azure SQL Database using BACPAC<\/li><li>Use an online method to migrate to Azure SQL Database<\/li><li>Move data to Azure SQL Database<\/li><li>Exercise - Migrate a SQL Server database to Azure SQL Database<\/li><li>Module assessment<\/li><li>Summary<\/li><\/ul>\n<h4>Migrate SQL Server workloads to Azure SQL Managed Instance<\/h4><ul>\n<li>Introduction<\/li><li>Evaluate migration scenarios<\/li><li>Migrate using Azure Arc<\/li><li>Use Log Replay Service (LRS) to migrate<\/li><li>Migrate using Managed Instance link<\/li><li>Move data to SQL Managed Instance<\/li><li>Exercise - Migrate a SQL Server database to Azure SQL Managed Instance<\/li><li>Module assessment<\/li><li>Summary<\/li><\/ul>\n<h4>Perform post-migration tasks on Azure SQL<\/h4><ul>\n<li>Introduction<\/li><li>Migrate SQL logins and groups<\/li><li>Implement security to protect Azure SQL<\/li><li>Implement compliance controls for sensitive data<\/li><li>Monitor database performance<\/li><li>Configure high availability and disaster recovery<\/li><li>Automate database tasks for scalability<\/li><li>Exercise: Configure geo-replication for Azure SQL Database<\/li><li>Module assessment<\/li><li>Summary<\/li><\/ul>","summary":"<p>Learn how to perform online and offline SQL Server migrations to Azure SQL<\/p>","essentials_plain":"- Experience with SQL Server databases.\n- Knowledge of SQL Server editions and versions.\n- Basic knowledge of security concepts like identities and permissions.\n- Experience using the Azure portal to create resources and set permissions.","contents_plain":"Design a SQL Server migration strategy\n\n\n- Introduction\n- Examine data platform modernization\n- Plan a data migration\n- Explore the available data migration technologies\n- Exercise: Compare on-premises Azure costs\n- Module assessment\n- Summary\n\nAssess SQL Server databases for migration to Azure SQL\n\n\n- Introduction\n- Review database for compatibility\n- Explore assessment options for database migration\n- Assess SQL Server with Azure Arc\n- Assess a database with Azure Migrate\n- Exercise: Identify compatibility issues\n- Module assessment\n- Summary\n\nDeploy IaaS solutions with Azure SQL\n\n\n- Introduction\n- Explain IaaS options to deploy SQL Server in Azure\n- Understand hybrid scenarios\n- Explore performance and security\n- Explain high availability and disaster recovery options\n- Exercise: Provision a SQL Server on an Azure Virtual Machine\n- Module assessment\n- Summary\n\nDeploy PaaS solutions with Azure SQL\n\n\n- Introduction\n- Explain PaaS options for deploying SQL Server in Azure\n- Explore single SQL database\n- Deploy SQL database elastic pool\n- Understand SQL database hyperscale\n- Examine SQL managed instance\n- Exercise: Deploy an Azure SQL Database\n- Module assessment\n- Summary\n\nMigrate SQL Server workloads to Azure Virtual Machine\n\n\n- Introduction\n- Review migrations strategies and tools\n- Understand distributed availability group for migration\n- Migrate databases using native backup and restore\n- Compare additional migration methods\n- Exercise: Migrate SQL Server databases to SQL Server on Azure Virtual Machine\n- Module assessment\n- Summary\n\nMigrate SQL Server workloads to Azure SQL Database\n\n\n- Introduction\n- Choose the right Azure SQL Database feature\n- Use Azure Database Migration Service to migrate to Azure SQL Database\n- Migrate to Azure SQL Database using BACPAC\n- Use an online method to migrate to Azure SQL Database\n- Move data to Azure SQL Database\n- Exercise - Migrate a SQL Server database to Azure SQL Database\n- Module assessment\n- Summary\n\nMigrate SQL Server workloads to Azure SQL Managed Instance\n\n\n- Introduction\n- Evaluate migration scenarios\n- Migrate using Azure Arc\n- Use Log Replay Service (LRS) to migrate\n- Migrate using Managed Instance link\n- Move data to SQL Managed Instance\n- Exercise - Migrate a SQL Server database to Azure SQL Managed Instance\n- Module assessment\n- Summary\n\nPerform post-migration tasks on Azure SQL\n\n\n- Introduction\n- Migrate SQL logins and groups\n- Implement security to protect Azure SQL\n- Implement compliance controls for sensitive data\n- Monitor database performance\n- Configure high availability and disaster recovery\n- Automate database tasks for scalability\n- Exercise: Configure geo-replication for Azure SQL Database\n- Module assessment\n- Summary","summary_plain":"Learn how to perform online and offline SQL Server migrations to Azure SQL","skill_level":"Intermediate","version":"A","duration":{"unit":"d","value":1,"formatted":"1 jour"},"pricelist":{"List Price":{"IT":{"country":"IT","currency":"EUR","taxrate":20,"price":490},"DE":{"country":"DE","currency":"EUR","taxrate":19,"price":690},"AT":{"country":"AT","currency":"EUR","taxrate":20,"price":690},"SE":{"country":"SE","currency":"EUR","taxrate":25,"price":690},"NL":{"country":"NL","currency":"EUR","taxrate":21,"price":645},"US":{"country":"US","currency":"USD","taxrate":null,"price":675},"CA":{"country":"CA","currency":"CAD","taxrate":null,"price":675},"GB":{"country":"GB","currency":"GBP","taxrate":20,"price":940},"PL":{"country":"PL","currency":"PLN","taxrate":23,"price":1200},"CH":{"country":"CH","currency":"CHF","taxrate":8.1,"price":420},"SI":{"country":"SI","currency":"EUR","taxrate":20,"price":690},"FR":{"country":"FR","currency":"EUR","taxrate":19.6,"price":950}}},"lastchanged":"2026-07-06T11:10:04+02:00","parenturl":"https:\/\/portal.flane.ch\/swisscom\/fr\/json-courses","nexturl_course_schedule":"https:\/\/portal.flane.ch\/swisscom\/fr\/json-course-schedule\/34137","source_lang":"fr","source":"https:\/\/portal.flane.ch\/swisscom\/fr\/json-course\/microsoft-dp-3001"}}