{"id":78119,"date":"2021-04-01T22:00:56","date_gmt":"2021-04-01T22:00:56","guid":{"rendered":"https:\/\/www.whizlabs.com\/blog\/?p=78119"},"modified":"2021-07-23T04:09:44","modified_gmt":"2021-07-23T09:39:44","slug":"how-to-migrate-your-on-prem-sql-server-db-to-azure-cloud","status":"publish","type":"post","link":"https:\/\/www.whizlabs.com\/blog\/how-to-migrate-your-on-prem-sql-server-db-to-azure-cloud\/","title":{"rendered":"How to Migrate Your On-Prem SQL Server DB to Azure Cloud"},"content":{"rendered":"<p><span style=\"font-weight: 400;\">Azure SQL is a family of cloud relational databases that Microsoft offers as a service on Azure. These databases are powered by a <\/span><b>SQL Server Engine<\/b><span style=\"font-weight: 400;\"> which consistently goes through monumental updates and improvements by Microsoft to ensure enhanced efficiency.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">While Microsoft continues to support its on-prem setup of the Microsoft SQL Server product, more capabilities and extended support are provided on the cloud, delivering solutions that leverage the ever-growing data demands in today\u2019s information age.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Today, Microsoft has three offerings that make up the entire Azure SQL family, which are:\u00a0<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">SQL Server on Azure Virtual Machines,\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Azure SQL Managed Instance, and\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Azure SQL Database.<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">Each service has its benefits, and choosing one over the other depends on the business and technical teams\u2019 goals.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">The table below points out some of the main reasons teams could choose one service over the other.<\/span><\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-78209\" src=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Screenshot-2021-04-02-7.09.14-PM.png\" alt=\"Azure SQL Family Differences\" width=\"825\" height=\"191\" srcset=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Screenshot-2021-04-02-7.09.14-PM.png 825w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Screenshot-2021-04-02-7.09.14-PM-300x69.png 300w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Screenshot-2021-04-02-7.09.14-PM-768x178.png 768w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Screenshot-2021-04-02-7.09.14-PM-640x148.png 640w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Screenshot-2021-04-02-7.09.14-PM-681x158.png 681w\" sizes=\"(max-width: 825px) 100vw, 825px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p style=\"text-align: left;\"><span style=\"font-weight: 400;\">The Azure SQL-managed instance lies between Infrastructure as a service and Platform as a service offering, providing database administrators the capability to manage parts of SQL Server\u2019s infrastructure components. Let us go through the steps to migrating your existing database to an Azure SQL-managed instance.\u00a0<\/span><\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_76 ez-toc-wrap-left counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #ea7e02;color:#ea7e02\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #ea7e02;color:#ea7e02\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.whizlabs.com\/blog\/how-to-migrate-your-on-prem-sql-server-db-to-azure-cloud\/#Section_1_Getting_Started\" >Section 1: Getting Started<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.whizlabs.com\/blog\/how-to-migrate-your-on-prem-sql-server-db-to-azure-cloud\/#Prerequisites\" >Prerequisites:<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.whizlabs.com\/blog\/how-to-migrate-your-on-prem-sql-server-db-to-azure-cloud\/#Section_2_Create_an_Azure_SQL_Managed_Instance\" >Section 2: Create an Azure SQL Managed Instance.<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.whizlabs.com\/blog\/how-to-migrate-your-on-prem-sql-server-db-to-azure-cloud\/#Section_3_Create_a_Data_Migration_Service\" >Section 3: Create a Data Migration Service.<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.whizlabs.com\/blog\/how-to-migrate-your-on-prem-sql-server-db-to-azure-cloud\/#Step_1_Register_the_MicrosoftDataMigration_resource_provider\" >Step 1: Register the Microsoft.DataMigration resource provider.<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/www.whizlabs.com\/blog\/how-to-migrate-your-on-prem-sql-server-db-to-azure-cloud\/#Step_2_Create_the_Azure_Database_Migration_service\" >Step 2: Create the Azure Database Migration service.<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/www.whizlabs.com\/blog\/how-to-migrate-your-on-prem-sql-server-db-to-azure-cloud\/#Section_4_Create_a_Migration_Project\" >Section 4: Create a Migration Project.<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/www.whizlabs.com\/blog\/how-to-migrate-your-on-prem-sql-server-db-to-azure-cloud\/#Step1_Create_a_new_migration_project\" >Step1: Create a new migration project.<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/www.whizlabs.com\/blog\/how-to-migrate-your-on-prem-sql-server-db-to-azure-cloud\/#Section_5_Trigger_the_Migration_Activity\" >Section 5: Trigger the Migration Activity.<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/www.whizlabs.com\/blog\/how-to-migrate-your-on-prem-sql-server-db-to-azure-cloud\/#Step_1_Create_an_Azure_AD_Application_ID_and_service_principal\" >Step 1: Create an Azure AD Application ID and service principal.<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/www.whizlabs.com\/blog\/how-to-migrate-your-on-prem-sql-server-db-to-azure-cloud\/#Troubleshooting_Common_Migration_Issues\" >Troubleshooting Common Migration Issues<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/www.whizlabs.com\/blog\/how-to-migrate-your-on-prem-sql-server-db-to-azure-cloud\/#Checkout_Whizlabs_Microsoft_Azure_Certification_courses_here\" >Checkout Whizlabs Microsoft Azure Certification courses here!<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/www.whizlabs.com\/blog\/how-to-migrate-your-on-prem-sql-server-db-to-azure-cloud\/#Conclusion\" >Conclusion<\/a><\/li><\/ul><\/nav><\/div>\n<h2 style=\"text-align: left;\"><span class=\"ez-toc-section\" id=\"Section_1_Getting_Started\"><\/span><b>Section 1:<\/b><span style=\"font-weight: 400;\"> Getting Started<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3><span class=\"ez-toc-section\" id=\"Prerequisites\"><\/span><span style=\"font-weight: 400;\">Prerequisites:<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ol>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">A Microsoft Azure Subscription.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">A resource group to place newly created Azure services.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">An Azure virtual network for the SQL server-managed instance.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Ensure that you have existing <\/span><b>site-to-site VPN<\/b><span style=\"font-weight: 400;\"> connectivity to the Azure cloud, i.e., Azure VPN gateway or Express route connection. If you don\u2019t have a site-to-site VPN setup, you can use the Azure Data Migration service in <\/span><b>hybrid mode<\/b><span style=\"font-weight: 400;\">.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">An <\/span><b>Azure storage account<\/b><span style=\"font-weight: 400;\"> of standard performance tier, allowing all network access.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">To enable the Data migration service to access the on-premise SQL server, open <\/span><b>port 1433<\/b><span style=\"font-weight: 400;\"> or any other port used by the database engine on your firewall.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Ensure that you have an <\/span><b>SMB share<\/b><span style=\"font-weight: 400;\"> that contains all the database backups and log files and open <\/span><b>port 445<\/b><span style=\"font-weight: 400;\"> on your firewall to allow the Data migration service to access the shared folder.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Ensure that the logins used to connect the source SQL Server and the target SQL Managed Instance are members of the <\/span><b>Service Administrator Server Role<\/b><span style=\"font-weight: 400;\">.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">The source SQL server\u2019s service administrator account should have <\/span><i><span style=\"font-weight: 400;\">write<\/span><\/i><span style=\"font-weight: 400;\"> privileges on the network share, and the source SQL server service account should have <\/span><i><span style=\"font-weight: 400;\">read\/write<\/span><\/i><span style=\"font-weight: 400;\"> access to that shared folder.<\/span><\/li>\n<\/ol>\n<p><b>Quick Note:<\/b><b>\u00a0<\/b><\/p>\n<p><span style=\"font-weight: 400;\">Migration from on-prem SQL Server to Azure Cloud supports all <\/span><b>Microsoft SQL<\/b> <b>Server versions of 2005<\/b><span style=\"font-weight: 400;\"> through <\/span><b>Microsoft SQL Server 2019<\/b><span style=\"font-weight: 400;\">.<\/span><\/p>\n<h4><span style=\"font-weight: 400;\">Data Migration Tools<\/span><\/h4>\n<ol>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>Data Migration Assistant<\/b><span style=\"font-weight: 400;\">: Assess your current database by performing compatibility checks and generate reports to see recommendations before deciding to move your database to a new Azure SQL server.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>Data Migration Service<\/b><span style=\"font-weight: 400;\">: This is a managed service in Azure and adds to the Data migration assistant\u2019s capabilities, allowing you to perform bulk migrations of on-premises Microsoft SQL Server databases to Azure.<\/span><\/li>\n<\/ol>\n<p><span style=\"font-weight: 400;\">In this article, we will focus on using the <\/span><b>Data Migration service<\/b><span style=\"font-weight: 400;\"> to perform end-to-end database migration activities.<\/span><\/p>\n<h4><span style=\"font-weight: 400;\">Online versus Offline migrations<\/span><\/h4>\n<p><span style=\"font-weight: 400;\">Depending on the application availability requirements, teams can choose an online migration if the goal is to have minimal downtime, and time is lost only when the cutover activity is initiated. With offline migrations, all databases are shut down and migrated similarly.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">In this article, we will cover both online and offline migration scenarios.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Section_2_Create_an_Azure_SQL_Managed_Instance\"><\/span><b>Section 2:<\/b><span style=\"font-weight: 400;\"> Create an Azure SQL Managed Instance.<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><b>Step 1:<\/b><span style=\"font-weight: 400;\"> Create an Azure SQL Managed Instance.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">A. In the Azure portal, search for <\/span><b><i>SQL managed instances.<\/i><\/b><img decoding=\"async\" class=\"aligncenter size-full wp-image-78128\" src=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Azure-SQL-Managed-Instance-SQL-managed-instances.png\" alt=\"Azure SQL Managed Instance - SQL managed instances\" width=\"512\" height=\"196\" srcset=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Azure-SQL-Managed-Instance-SQL-managed-instances.png 512w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Azure-SQL-Managed-Instance-SQL-managed-instances-300x115.png 300w\" sizes=\"(max-width: 512px) 100vw, 512px\" \/><\/p>\n<p>B. A display showing all managed instances within your Azure AD Tenant will appear. Since we have none yet, click on the button <b><i>Create SQL managed instance<\/i><\/b><i>.<\/i><img decoding=\"async\" class=\"aligncenter wp-image-78129 size-full\" src=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Azure-SQL-Managed-Instance-Create-SQL-managed-instance.png\" alt=\"Azure SQL Managed Instance - Create SQL managed instance\" width=\"512\" height=\"303\" srcset=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Azure-SQL-Managed-Instance-Create-SQL-managed-instance.png 512w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Azure-SQL-Managed-Instance-Create-SQL-managed-instance-300x178.png 300w\" sizes=\"(max-width: 512px) 100vw, 512px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">C. On the next screen, select the <\/span><b><i>Subscription<\/i><\/b><span style=\"font-weight: 400;\"> and <\/span><b><i>Resource group<\/i><\/b><span style=\"font-weight: 400;\">. Also, name the managed instance, set its location, and click on the <\/span><b><i>Configure Managed Instance<\/i><\/b><span style=\"font-weight: 400;\"> link.<\/span><span style=\"font-weight: 400;\"><img decoding=\"async\" class=\"aligncenter size-full wp-image-78130\" src=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Azure-SQL-Managed-Instance-Configure-Managed-Instance-.png\" alt=\"Azure SQL Managed Instance - Configure Managed Instance\" width=\"413\" height=\"512\" srcset=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Azure-SQL-Managed-Instance-Configure-Managed-Instance-.png 413w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Azure-SQL-Managed-Instance-Configure-Managed-Instance--242x300.png 242w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Azure-SQL-Managed-Instance-Configure-Managed-Instance--339x420.png 339w\" sizes=\"(max-width: 413px) 100vw, 413px\" \/><\/span><b>Quick tip<\/b>: The name of the managed instance should be globally unique.<\/p>\n<p>D. Once you click on the link, the following page will appear, and a list of options to select from for the managed instance specifications will be shown, click <b><i>Apply <\/i><\/b>after selection.<\/p>\n<ul>\n<li style=\"list-style-type: none;\">\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>Service tier:<\/b><span style=\"font-weight: 400;\"> Select the General purpose or Business-critical workloads depending on your current resource usage for the on-prem SQL Server database infrastructure.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>Compute hardware:<\/b><span style=\"font-weight: 400;\"> Generation is <\/span><b>Gen5<\/b><span style=\"font-weight: 400;\"> by default, set the number of vCores and the required storage space for the database transactional data files.<\/span><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-78131\" src=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Service-tier-and-compute-hardware.png\" alt=\"Service tier and compute hardware\" width=\"1054\" height=\"1030\" srcset=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Service-tier-and-compute-hardware.png 1054w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Service-tier-and-compute-hardware-300x293.png 300w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Service-tier-and-compute-hardware-1024x1001.png 1024w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Service-tier-and-compute-hardware-768x751.png 768w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Service-tier-and-compute-hardware-430x420.png 430w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Service-tier-and-compute-hardware-640x625.png 640w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Service-tier-and-compute-hardware-681x665.png 681w\" sizes=\"(max-width: 1054px) 100vw, 1054px\" \/><\/p>\n<p><b>Quick Tip<\/b><span style=\"font-weight: 400;\">:\u00a0<\/span><\/p>\n<ol>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Select both checkboxes within the <\/span><b><i>Azure Hybrid Benefits<\/i><\/b><span style=\"font-weight: 400;\"> section if you want to reuse some of your on-prem SQL server licenses to save on the licensing charges for your managed instance.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Choose <\/span><b><i>Geo-redundant backup storage<\/i><\/b><span style=\"font-weight: 400;\"> if you prefer to backup your databases to multiple Azure cloud regions and perform full database restoration in case of an Azure regional failure.<\/span><\/li>\n<\/ol>\n<p>E. <span style=\"font-weight: 400;\">Once you click <\/span><b><i>Next<\/i><\/b><span style=\"font-weight: 400;\">, the following tab is the Networking section. Click on the drop-down and select the<\/span><b><i> Virtual network<\/i><\/b><span style=\"font-weight: 400;\"> of your Azure SQL Managed Instance.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Unless there is a specific setup required for your instance, the rest of the settings should be left with their defaults and click <\/span><b><i>Next:<\/i><\/b> <b><i>Additional settings<\/i><\/b><i><span style=\"font-weight: 400;\">.<\/span><\/i><\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-78132\" src=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Azure-SQL-Managed-Instance-Virtual-Network-Additional-settings.png\" alt=\"Azure-SQL-Managed-Instance-Virtual-Network-Additional-settings\" width=\"403\" height=\"512\" srcset=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Azure-SQL-Managed-Instance-Virtual-Network-Additional-settings.png 403w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Azure-SQL-Managed-Instance-Virtual-Network-Additional-settings-236x300.png 236w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Azure-SQL-Managed-Instance-Virtual-Network-Additional-settings-331x420.png 331w\" sizes=\"(max-width: 403px) 100vw, 403px\" \/><\/p>\n<p><b>Quick Tip<\/b><span style=\"font-weight: 400;\">:<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Use <\/span><b>VNet peering<\/b><span style=\"font-weight: 400;\"> on the Azure SQL Managed Instance\u2019s Virtual network to enable private TCP\/IP communication with the Azure VPN Gateway subnet.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">F. On the additional settings, Find and select the <\/span><b><i>Collation<\/i><\/b><span style=\"font-weight: 400;\"> similar to the on-prem SQL Server instance, the <\/span><b><i>Time zone<\/i><\/b><span style=\"font-weight: 400;\">, and leave the <\/span><b><i>Geo-Replication<\/i><\/b><span style=\"font-weight: 400;\"> settings to their defaults.<\/span><\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-78133\" src=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Collation-Geo-Replication.png\" alt=\"Collation-Geo-Replication\" width=\"410\" height=\"512\" srcset=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Collation-Geo-Replication.png 410w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Collation-Geo-Replication-240x300.png 240w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Collation-Geo-Replication-336x420.png 336w\" sizes=\"(max-width: 410px) 100vw, 410px\" \/><\/p>\n<p><b>Quick Tip<\/b><span style=\"font-weight: 400;\">:\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Use failover groups if one of the main requirements is to maintain your databases\u2019 availability on the Azure SQL Managed instance across regions. Set up an additional managed instance in a different region and add a failover secondary to the primary instance.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">G. The next screen requires you to set up<\/span><b><i> Tags<\/i><\/b><span style=\"font-weight: 400;\"> with most Azure services for billing purposes. If you don&#8217;t use tags, click to the next page, which validates and summarizes how we plan to create our managed instance. Click <\/span><b><i>Create<\/i><\/b><span style=\"font-weight: 400;\">.<\/span><\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-78134\" src=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Azure-SQL-Managed-Instance-Tags-create.png\" alt=\"Azure SQL Managed Instance - Tags-create\" width=\"726\" height=\"277\" srcset=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Azure-SQL-Managed-Instance-Tags-create.png 726w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Azure-SQL-Managed-Instance-Tags-create-300x114.png 300w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Azure-SQL-Managed-Instance-Tags-create-640x244.png 640w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Azure-SQL-Managed-Instance-Tags-create-681x260.png 681w\" sizes=\"(max-width: 726px) 100vw, 726px\" \/><\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-78135\" src=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Azure-SQL-Managed-Instance-Tags-create-2.png\" alt=\"Azure SQL Managed Instance - Tags-create 2\" width=\"407\" height=\"512\" srcset=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Azure-SQL-Managed-Instance-Tags-create-2.png 407w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Azure-SQL-Managed-Instance-Tags-create-2-238x300.png 238w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Azure-SQL-Managed-Instance-Tags-create-2-334x420.png 334w\" sizes=\"(max-width: 407px) 100vw, 407px\" \/><\/p>\n<p>H. <span style=\"font-weight: 400;\">The deployment of a managed instance takes a long creation time and could take up to <\/span><b>4 hours<\/b><span style=\"font-weight: 400;\">. In our case, while writing this article, it took a total of 3 hours. We will then click <\/span><b><i>Go to resource<\/i><\/b><span style=\"font-weight: 400;\"> to access the newly created instance.<\/span><\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-78136\" src=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Azure-SQL-Managed-Instance-Go-to-resource.png\" alt=\"Azure SQL Managed Instance - Go to resource\" width=\"512\" height=\"235\" srcset=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Azure-SQL-Managed-Instance-Go-to-resource.png 512w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Azure-SQL-Managed-Instance-Go-to-resource-300x138.png 300w\" sizes=\"(max-width: 512px) 100vw, 512px\" \/><\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-78137\" src=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Azure-SQL-Managed-Instance-Go-to-resource-2.png\" alt=\"Azure SQL Managed Instance - Go to resource 2\" width=\"512\" height=\"192\" srcset=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Azure-SQL-Managed-Instance-Go-to-resource-2.png 512w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Azure-SQL-Managed-Instance-Go-to-resource-2-300x113.png 300w\" sizes=\"(max-width: 512px) 100vw, 512px\" \/><\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-78138\" src=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Azure-SQL-Managed-Instance-Go-to-resource-3.png\" alt=\"Azure SQL Managed Instance - Go to resource 3\" width=\"512\" height=\"407\" srcset=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Azure-SQL-Managed-Instance-Go-to-resource-3.png 512w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Azure-SQL-Managed-Instance-Go-to-resource-3-300x238.png 300w\" sizes=\"(max-width: 512px) 100vw, 512px\" \/><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Section_3_Create_a_Data_Migration_Service\"><\/span><b>Section 3:<\/b><span style=\"font-weight: 400;\"> Create a Data Migration Service.<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">This section will cover how to create the Data Migration service required for our database migration.<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Step_1_Register_the_MicrosoftDataMigration_resource_provider\"><\/span><b>Step 1:<\/b><span style=\"font-weight: 400;\"> Register the Microsoft.DataMigration resource provider.<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ol>\n<li style=\"list-style-type: none;\">\n<ol>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">In the Azure portal, search for subscriptions.<br \/>\n<img decoding=\"async\" class=\"aligncenter size-full wp-image-78139\" src=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Register-the-Microsoft.DataMigration-resource-provider.png\" alt=\"Register the Microsoft.DataMigration resource provider\" width=\"972\" height=\"211\" srcset=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Register-the-Microsoft.DataMigration-resource-provider.png 972w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Register-the-Microsoft.DataMigration-resource-provider-300x65.png 300w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Register-the-Microsoft.DataMigration-resource-provider-768x167.png 768w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Register-the-Microsoft.DataMigration-resource-provider-640x139.png 640w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Register-the-Microsoft.DataMigration-resource-provider-681x148.png 681w\" sizes=\"(max-width: 972px) 100vw, 972px\" \/><br \/>\n<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">On the selected subscription, click on the <\/span><b><i>Resource providers<\/i><\/b><span style=\"font-weight: 400;\"> blade.<br \/>\n<img decoding=\"async\" class=\"aligncenter size-full wp-image-78140\" src=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Create-a-data-migration-service-Resource-providers.png\" alt=\"Create a data migration service - Resource providers\" width=\"512\" height=\"409\" srcset=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Create-a-data-migration-service-Resource-providers.png 512w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Create-a-data-migration-service-Resource-providers-300x240.png 300w\" sizes=\"(max-width: 512px) 100vw, 512px\" \/><br \/>\n<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\">Search for <b>migration<\/b> and click on <b><i>Register<\/i><\/b> the <b>Microsoft.DataMigration<\/b> resource provider.<br \/>\n<img decoding=\"async\" class=\"aligncenter size-full wp-image-78142\" src=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Create-a-Data-Migration-Service-Microsoft.DataMigration.png\" alt=\"Create a Data Migration Service - Microsoft.DataMigration\" width=\"512\" height=\"243\" srcset=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Create-a-Data-Migration-Service-Microsoft.DataMigration.png 512w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Create-a-Data-Migration-Service-Microsoft.DataMigration-300x142.png 300w\" sizes=\"(max-width: 512px) 100vw, 512px\" \/><img decoding=\"async\" class=\"aligncenter size-full wp-image-78143\" src=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Create-a-Data-Migration-Service-Microsoft.DataMigration-2.png\" alt=\"Create a Data Migration Service - Microsoft.DataMigration 2\" width=\"512\" height=\"258\" srcset=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Create-a-Data-Migration-Service-Microsoft.DataMigration-2.png 512w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Create-a-Data-Migration-Service-Microsoft.DataMigration-2-300x151.png 300w\" sizes=\"(max-width: 512px) 100vw, 512px\" \/><\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<h3><span class=\"ez-toc-section\" id=\"Step_2_Create_the_Azure_Database_Migration_service\"><\/span><b>Step 2: <\/b><span style=\"font-weight: 400;\">Create the Azure Database Migration service.<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400;\">A. Access the Azure portal and search for the <\/span><b><i>Azure Database Migration Services. <\/i><\/b><span style=\"font-weight: 400;\">Click<\/span> <b><i>Create azure database migration service<\/i><\/b><b>.<br \/>\n<img decoding=\"async\" class=\"aligncenter size-full wp-image-78144\" src=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Azure-Database-Migration-Services.png\" alt=\"Azure Database Migration Services\" width=\"512\" height=\"102\" srcset=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Azure-Database-Migration-Services.png 512w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Azure-Database-Migration-Services-300x60.png 300w\" sizes=\"(max-width: 512px) 100vw, 512px\" \/><img decoding=\"async\" class=\"aligncenter size-full wp-image-78145\" src=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Create-Azure-Database-Migration-Services.png\" alt=\"Create Azure Database Migration Services\" width=\"1028\" height=\"692\" srcset=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Create-Azure-Database-Migration-Services.png 1028w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Create-Azure-Database-Migration-Services-300x202.png 300w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Create-Azure-Database-Migration-Services-1024x689.png 1024w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Create-Azure-Database-Migration-Services-768x517.png 768w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Create-Azure-Database-Migration-Services-624x420.png 624w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Create-Azure-Database-Migration-Services-537x360.png 537w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Create-Azure-Database-Migration-Services-640x431.png 640w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Create-Azure-Database-Migration-Services-681x458.png 681w\" sizes=\"(max-width: 1028px) 100vw, 1028px\" \/><\/b><\/p>\n<p><span style=\"font-weight: 400;\">B. On the next screen, select the <\/span><b><i>Subscription<\/i><\/b><span style=\"font-weight: 400;\"> and <\/span><b><i>Resource group<\/i><\/b><span style=\"font-weight: 400;\">,\u00a0 and name the migration service, set location, select the Azure service mode and click <\/span><b><i>Configure tier.<\/i><\/b><\/p>\n<p><b>Quick tip<\/b><span style=\"font-weight: 400;\">: Setting <\/span><b><i>hybrid mode<\/i><\/b><span style=\"font-weight: 400;\"> will enable the migration service to perform migrations over the public internet, requiring no Azure VPN gateway.<\/span><\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-78146\" src=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Azure-Database-Migration-Services-hybrid.png\" alt=\"Azure Database Migration Services - hybrid mode\" width=\"742\" height=\"912\" srcset=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Azure-Database-Migration-Services-hybrid.png 742w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Azure-Database-Migration-Services-hybrid-244x300.png 244w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Azure-Database-Migration-Services-hybrid-342x420.png 342w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Azure-Database-Migration-Services-hybrid-640x787.png 640w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Azure-Database-Migration-Services-hybrid-681x837.png 681w\" sizes=\"(max-width: 742px) 100vw, 742px\" \/><\/p>\n<p>C. On the <b><i>Configure<\/i><\/b> page, select the premium tier for online and offline migrations and click <b><i>Apply <\/i><\/b>and move onto the<b><i> Networking<\/i><\/b> tab.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-78147\" src=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Azure-Database-Migration-Services-Networking.png\" alt=\"Azure Database Migration Services - Networking\" width=\"738\" height=\"908\" srcset=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Azure-Database-Migration-Services-Networking.png 738w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Azure-Database-Migration-Services-Networking-244x300.png 244w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Azure-Database-Migration-Services-Networking-341x420.png 341w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Azure-Database-Migration-Services-Networking-640x787.png 640w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Azure-Database-Migration-Services-Networking-681x838.png 681w\" sizes=\"(max-width: 738px) 100vw, 738px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">D. On the <\/span><b><i>Networking<\/i><\/b><span style=\"font-weight: 400;\"> tab, select the Virtual Network that the migration service should use, and click <\/span><b><i>Next<\/i><\/b><span style=\"font-weight: 400;\">.<\/span><\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-78148\" src=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Azure-Database-Migration-Services-create.png\" alt=\"Azure Database Migration Services - create migration\" width=\"447\" height=\"512\" srcset=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Azure-Database-Migration-Services-create.png 447w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Azure-Database-Migration-Services-create-262x300.png 262w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Azure-Database-Migration-Services-create-367x420.png 367w\" sizes=\"(max-width: 447px) 100vw, 447px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"font-weight: 400;\">E. We shall not set tags for the migration service in our scenario. The final tab presents us with a summary of how we plan to set up our migration service. Click<\/span><b><i> Create<\/i><\/b><span style=\"font-weight: 400;\"> to submit the deployment.<\/span><\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-78149\" src=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Azure-Database-Migration-Services-Create-Review.png\" alt=\"Azure Database Migration Services -Create Review\" width=\"432\" height=\"512\" srcset=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Azure-Database-Migration-Services-Create-Review.png 432w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Azure-Database-Migration-Services-Create-Review-253x300.png 253w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Azure-Database-Migration-Services-Create-Review-354x420.png 354w\" sizes=\"(max-width: 432px) 100vw, 432px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">F. Our new migration service is created successfully.<\/span><\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-78150\" src=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Azure-Database-Migration-Services-created-succesfully.png\" alt=\"Azure Database Migration Services -created successfully\" width=\"941\" height=\"618\" srcset=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Azure-Database-Migration-Services-created-succesfully.png 941w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Azure-Database-Migration-Services-created-succesfully-300x197.png 300w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Azure-Database-Migration-Services-created-succesfully-768x504.png 768w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Azure-Database-Migration-Services-created-succesfully-640x420.png 640w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Azure-Database-Migration-Services-created-succesfully-681x447.png 681w\" sizes=\"(max-width: 941px) 100vw, 941px\" \/><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Section_4_Create_a_Migration_Project\"><\/span><b>Section 4:<\/b><span style=\"font-weight: 400;\"> Create a Migration Project.<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3><span class=\"ez-toc-section\" id=\"Step1_Create_a_new_migration_project\"><\/span><b>Step1:<\/b><span style=\"font-weight: 400;\"> Create a new migration project.<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400;\">A. Access the previously created Azure Data Migration service, and click <\/span><b><i>New migration project.<\/i><\/b><\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-78151\" src=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Create-a-Migration-Project-new-migration-project.png\" alt=\"Create a Migration Project - new migration project\" width=\"862\" height=\"399\" srcset=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Create-a-Migration-Project-new-migration-project.png 862w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Create-a-Migration-Project-new-migration-project-300x139.png 300w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Create-a-Migration-Project-new-migration-project-768x355.png 768w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Create-a-Migration-Project-new-migration-project-640x296.png 640w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Create-a-Migration-Project-new-migration-project-681x315.png 681w\" sizes=\"(max-width: 862px) 100vw, 862px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">B. A screen will appear that asks us to enter the migration project name, source, and target server type: <\/span><b><i>SQL Server<\/i><\/b><span style=\"font-weight: 400;\"> and <\/span><b><i>Azure SQL Database Managed Instance<\/i><\/b><span style=\"font-weight: 400;\">. The migration activity type is <\/span><b><i>Online data migration<\/i><\/b><span style=\"font-weight: 400;\">. Then click <\/span><b><i>create and run activity<\/i><\/b><span style=\"font-weight: 400;\"> after filing in the required fields.<\/span><\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-78152\" src=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Create-a-Migration-Project.png\" alt=\"Create a Migration Project\" width=\"678\" height=\"833\" srcset=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Create-a-Migration-Project.png 678w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Create-a-Migration-Project-244x300.png 244w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Create-a-Migration-Project-342x420.png 342w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Create-a-Migration-Project-640x786.png 640w\" sizes=\"(max-width: 678px) 100vw, 678px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">C. After running the activity, we will be presented with the migration project wizard. Insert the source SQL Server <\/span><b><i>private IP address<\/i><\/b><span style=\"font-weight: 400;\">, select <\/span><b><i>Windows authentication, <\/i><\/b><span style=\"font-weight: 400;\">type the <\/span><b><i>user account and password <\/i><\/b><span style=\"font-weight: 400;\">with<\/span><b><i> administrator permissions<\/i><\/b><span style=\"font-weight: 400;\"> over the source SQL Server instance.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">D. Make sure to check both checkboxes on connection properties, then click <\/span><b><i>next<\/i><\/b><span style=\"font-weight: 400;\">.<\/span><\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-78153\" src=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Create-a-Migration-Project-1.png\" alt=\"Create a Migration Project\" width=\"678\" height=\"833\" srcset=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Create-a-Migration-Project-1.png 678w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Create-a-Migration-Project-1-244x300.png 244w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Create-a-Migration-Project-1-342x420.png 342w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Create-a-Migration-Project-1-640x786.png 640w\" sizes=\"(max-width: 678px) 100vw, 678px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">E. On the next tab, select the database for the online migration activity and click <\/span><b><i>Next<\/i><\/b><span style=\"font-weight: 400;\">.<\/span><\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-78154\" src=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Create-a-Migration-Project-1-1.png\" alt=\"Create a Migration Project 1\" width=\"967\" height=\"712\" srcset=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Create-a-Migration-Project-1-1.png 967w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Create-a-Migration-Project-1-1-300x221.png 300w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Create-a-Migration-Project-1-1-768x565.png 768w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Create-a-Migration-Project-1-1-570x420.png 570w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Create-a-Migration-Project-1-1-80x60.png 80w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Create-a-Migration-Project-1-1-100x75.png 100w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Create-a-Migration-Project-1-1-640x471.png 640w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Create-a-Migration-Project-1-1-681x501.png 681w\" sizes=\"(max-width: 967px) 100vw, 967px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">F. On the target tab, copy and paste the server name for the target Azure SQL Managed Instance, set the authentication type to <\/span><b><i>SQL Authentication, <\/i><\/b><span style=\"font-weight: 400;\">type the username and password for the managed instance <\/span><b><i>administrator account<\/i><\/b><span style=\"font-weight: 400;\">, and then click <\/span><b><i>Next<\/i><\/b><span style=\"font-weight: 400;\">.<\/span><\/p>\n<p><b>Quick tip<\/b><span style=\"font-weight: 400;\">: The <\/span><b>Server name<\/b><span style=\"font-weight: 400;\"> for the managed instance is found on the default page of the new managed instance.<\/span><\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-78155\" src=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Create-a-Migration-Project-Services.png\" alt=\"Create a Migration Project Services\" width=\"512\" height=\"180\" srcset=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Create-a-Migration-Project-Services.png 512w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Create-a-Migration-Project-Services-300x105.png 300w\" sizes=\"(max-width: 512px) 100vw, 512px\" \/><\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-78156\" src=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Create-a-Migration-Project-project-whizard.png\" alt=\"Create a Migration Project - project wizard\" width=\"958\" height=\"707\" srcset=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Create-a-Migration-Project-project-whizard.png 958w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Create-a-Migration-Project-project-whizard-300x221.png 300w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Create-a-Migration-Project-project-whizard-768x567.png 768w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Create-a-Migration-Project-project-whizard-569x420.png 569w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Create-a-Migration-Project-project-whizard-80x60.png 80w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Create-a-Migration-Project-project-whizard-100x75.png 100w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Create-a-Migration-Project-project-whizard-640x472.png 640w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Create-a-Migration-Project-project-whizard-681x503.png 681w\" sizes=\"(max-width: 958px) 100vw, 958px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">G. On the summary screen, check that all the configurations are correct, and click <\/span><b><i>Save project<\/i><\/b><span style=\"font-weight: 400;\">.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Section_5_Trigger_the_Migration_Activity\"><\/span><b>Section 5:<\/b><span style=\"font-weight: 400;\"> Trigger the Migration Activity.<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3><span class=\"ez-toc-section\" id=\"Step_1_Create_an_Azure_AD_Application_ID_and_service_principal\"><\/span><b>Step 1:<\/b><span style=\"font-weight: 400;\"> Create an Azure AD Application ID and service principal.<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400;\">A. To create a new Application ID to use for the migration, search for <\/span><b><i>Azure Active Directory<\/i><\/b><span style=\"font-weight: 400;\"> in the Azure portal.<\/span><\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-78157\" src=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Azure-Active-Directory.png\" alt=\"Azure Active Directory\" width=\"512\" height=\"207\" srcset=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Azure-Active-Directory.png 512w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Azure-Active-Directory-300x121.png 300w\" sizes=\"(max-width: 512px) 100vw, 512px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">B. Once the Azure Active Directory service blades become active, click on the <\/span><b>App registrations<\/b><span style=\"font-weight: 400;\"> blade and select <\/span><b><i>New registration.<\/i><\/b><\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-78160\" src=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Azure-Active-Directory-New-Registration.png\" alt=\"Azure Active Directory New Registration\" width=\"512\" height=\"368\" srcset=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Azure-Active-Directory-New-Registration.png 512w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Azure-Active-Directory-New-Registration-300x216.png 300w\" sizes=\"(max-width: 512px) 100vw, 512px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">C. Type your new application\u2019s <\/span><b><i>Name<\/i><\/b><span style=\"font-weight: 400;\">, assign it a<\/span> <b><i>Redirect URI<\/i><\/b><span style=\"font-weight: 400;\">,<\/span> <span style=\"font-weight: 400;\">and<\/span> <span style=\"font-weight: 400;\">then click <\/span><b><i>Register<\/i><\/b><b>.<\/b><\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-78161\" src=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Azure-Active-Directory-Registration.png\" alt=\"Azure Active Directory - Registration\" width=\"512\" height=\"489\" srcset=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Azure-Active-Directory-Registration.png 512w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Azure-Active-Directory-Registration-300x287.png 300w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Azure-Active-Directory-Registration-440x420.png 440w\" sizes=\"(max-width: 512px) 100vw, 512px\" \/><\/p>\n<p><b>Quick Tip<\/b><span style=\"font-weight: 400;\">:<\/span><span style=\"font-weight: 400;\"> If you have multiple Azure tenants, you may want to select the second option under <\/span><b><i>Supported account types<\/i><\/b><span style=\"font-weight: 400;\"> to reuse the Application ID for database migrations in separate Azure AD tenants. However, this is not mandatory.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">D. Search for subscriptions in the Azure portal, select the subscription you are using for the Data Migration service, select <\/span><b>Access control (IAM)<\/b><span style=\"font-weight: 400;\">, and <\/span><b><i>Add role assignment<\/i><\/b><span style=\"font-weight: 400;\">.<\/span><\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-78163\" src=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Azure-Active-Directory-access-control.png\" alt=\"Azure Active Directory - access control\" width=\"553\" height=\"178\" srcset=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Azure-Active-Directory-access-control.png 553w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Azure-Active-Directory-access-control-300x97.png 300w\" sizes=\"(max-width: 553px) 100vw, 553px\" \/><\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-78162\" src=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Azure-Active-Directory-Add-new-role.png\" alt=\"Azure Active Directory - Add new role\" width=\"857\" height=\"533\" srcset=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Azure-Active-Directory-Add-new-role.png 857w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Azure-Active-Directory-Add-new-role-300x187.png 300w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Azure-Active-Directory-Add-new-role-768x478.png 768w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Azure-Active-Directory-Add-new-role-675x420.png 675w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Azure-Active-Directory-Add-new-role-640x398.png 640w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Azure-Active-Directory-Add-new-role-681x424.png 681w\" sizes=\"(max-width: 857px) 100vw, 857px\" \/><\/p>\n<p>E. Assign the <b><i>Contributor role<\/i><\/b> to the Data Migration Service service principal that we just created. Click <b><i>Save<\/i><\/b>.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-78164\" src=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Azure-Active-Directory-contributer-role.png\" alt=\"Azure Active Directory - contributor role\" width=\"415\" height=\"885\" srcset=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Azure-Active-Directory-contributer-role.png 415w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Azure-Active-Directory-contributer-role-141x300.png 141w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Azure-Active-Directory-contributer-role-197x420.png 197w\" sizes=\"(max-width: 415px) 100vw, 415px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">F. Access Azure Active Directory, obtain the <\/span><b><i>Application client ID<\/i><\/b><span style=\"font-weight: 400;\"> under App registrations and then create a <\/span><b><i>New client secret<\/i><\/b><span style=\"font-weight: 400;\"> for the registered data migration service application and service principal.<\/span><\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-78165\" src=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Azure-Active-Directory-new-client.png\" alt=\"Azure Active Directory - new client secret\" width=\"1127\" height=\"547\" srcset=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Azure-Active-Directory-new-client.png 1127w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Azure-Active-Directory-new-client-300x146.png 300w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Azure-Active-Directory-new-client-1024x497.png 1024w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Azure-Active-Directory-new-client-768x373.png 768w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Azure-Active-Directory-new-client-865x420.png 865w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Azure-Active-Directory-new-client-640x311.png 640w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Azure-Active-Directory-new-client-681x331.png 681w\" sizes=\"(max-width: 1127px) 100vw, 1127px\" \/><\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-78166\" src=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Azure-Active-Directory-new-client-secret-1.png\" alt=\"Azure Active Directory - new client secret 1\" width=\"943\" height=\"282\" srcset=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Azure-Active-Directory-new-client-secret-1.png 943w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Azure-Active-Directory-new-client-secret-1-300x90.png 300w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Azure-Active-Directory-new-client-secret-1-768x230.png 768w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Azure-Active-Directory-new-client-secret-1-640x191.png 640w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Azure-Active-Directory-new-client-secret-1-681x204.png 681w\" sizes=\"(max-width: 943px) 100vw, 943px\" \/><\/p>\n<p>G. Once done obtaining the client ID, head over to the <b><i>Certificates &amp; secrets<\/i><\/b> blade and click <b><i>New client secret<\/i><\/b>, assign it a name and an expiry period of your choice, then click <b><i>Add<\/i><\/b>.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-78167\" src=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Azure-Active-Directory-certificates-secrets.png\" alt=\"Azure Active Directory - certificates &amp; secrets\" width=\"512\" height=\"490\" srcset=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Azure-Active-Directory-certificates-secrets.png 512w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Azure-Active-Directory-certificates-secrets-300x287.png 300w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Azure-Active-Directory-certificates-secrets-439x420.png 439w\" sizes=\"(max-width: 512px) 100vw, 512px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">H. Copy the client secret value and keep it safe for future reference during the migration activity.<\/span><\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-78168\" src=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Azure-Active-Directory-certificates-secrets-2.png\" alt=\"Azure Active Directory - certificates &amp; secrets 2\" width=\"512\" height=\"114\" srcset=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Azure-Active-Directory-certificates-secrets-2.png 512w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Azure-Active-Directory-certificates-secrets-2-300x67.png 300w\" sizes=\"(max-width: 512px) 100vw, 512px\" \/><\/p>\n<h4><b>Step 2:<\/b><span style=\"font-weight: 400;\"> Start the online database migration activity (<\/span><b>Option-1<\/b><span style=\"font-weight: 400;\">).<\/span><\/h4>\n<p><span style=\"font-weight: 400;\">A. Access the Azure Database Migration Service and select the <\/span><b>Online migration project<\/b><span style=\"font-weight: 400;\"> that you created previously.<\/span><\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-78169\" src=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Online-database-migration-activity-Online-migration-project.png\" alt=\"Online database migration activity - Online migration project\" width=\"888\" height=\"441\" srcset=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Online-database-migration-activity-Online-migration-project.png 888w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Online-database-migration-activity-Online-migration-project-300x149.png 300w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Online-database-migration-activity-Online-migration-project-768x381.png 768w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Online-database-migration-activity-Online-migration-project-846x420.png 846w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Online-database-migration-activity-Online-migration-project-640x318.png 640w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Online-database-migration-activity-Online-migration-project-681x338.png 681w\" sizes=\"(max-width: 888px) 100vw, 888px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">B. Click <\/span><b><i>New Activity<\/i><\/b><span style=\"font-weight: 400;\"> and select <\/span><b><i>Online data migratio<\/i><\/b><b>n<\/b><span style=\"font-weight: 400;\">.<\/span><\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-78170\" src=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Online-database-migration-activity-new-activity.png\" alt=\"Online database migration activity - new activity\" width=\"962\" height=\"613\" srcset=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Online-database-migration-activity-new-activity.png 962w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Online-database-migration-activity-new-activity-300x191.png 300w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Online-database-migration-activity-new-activity-768x489.png 768w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Online-database-migration-activity-new-activity-659x420.png 659w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Online-database-migration-activity-new-activity-640x408.png 640w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Online-database-migration-activity-new-activity-681x434.png 681w\" sizes=\"(max-width: 962px) 100vw, 962px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">C. Insert the source SQL server <\/span><b><i>IP address<\/i><\/b><span style=\"font-weight: 400;\">, select <\/span><b><i>Windows authentication,<\/i><\/b><span style=\"font-weight: 400;\"> and insert the username and password<\/span> <span style=\"font-weight: 400;\">for the source SQL Server<\/span><i><span style=\"font-weight: 400;\">.<br \/>\n<\/span><\/i><span style=\"font-weight: 400;\">Make sure to check both <\/span><b><i>Connection properties<\/i><\/b><span style=\"font-weight: 400;\"> checkboxes before clicking next.<\/span><\/p>\n<p><span style=\"font-weight: 400;\"><img decoding=\"async\" class=\"aligncenter size-full wp-image-78171\" src=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Online-database-migration-activity-Connection-properties.png\" alt=\"Online database migration activity - Connection properties\" width=\"466\" height=\"512\" srcset=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Online-database-migration-activity-Connection-properties.png 466w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Online-database-migration-activity-Connection-properties-273x300.png 273w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Online-database-migration-activity-Connection-properties-382x420.png 382w\" sizes=\"(max-width: 466px) 100vw, 466px\" \/><\/span><\/p>\n<p><span style=\"font-weight: 400;\">D. On the next tab, insert the <\/span><b><i>Application ID<\/i><\/b><span style=\"font-weight: 400;\"> and <\/span><b><i>Client secret value<\/i><\/b><span style=\"font-weight: 400;\"> you created in <\/span><b>Step 1<\/b><span style=\"font-weight: 400;\">. Select the subscription and target Azure SQL managed instance, SQL username, and password for the managed instance. Then click <\/span><b><i>Next<\/i><\/b><span style=\"font-weight: 400;\">.<\/span><\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-78172\" src=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Online-database-migration-activity-client-secret-value.png\" alt=\"Online database migration activity - client secret value\" width=\"757\" height=\"840\" srcset=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Online-database-migration-activity-client-secret-value.png 757w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Online-database-migration-activity-client-secret-value-270x300.png 270w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Online-database-migration-activity-client-secret-value-379x420.png 379w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Online-database-migration-activity-client-secret-value-640x710.png 640w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Online-database-migration-activity-client-secret-value-681x756.png 681w\" sizes=\"(max-width: 757px) 100vw, 757px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">E. On the next tab, select the <\/span><b><i>Database<\/i><\/b><span style=\"font-weight: 400;\"> to migrate online and click <\/span><b><i>Next<\/i><\/b><span style=\"font-weight: 400;\"> to configure the migration settings. Set the location of the<\/span> <b><i>Shared backups folder<\/i><\/b><span style=\"font-weight: 400;\">, the <\/span><b><i>user account<\/i><\/b><span style=\"font-weight: 400;\"> with privileges to the folder, and the <\/span><b><i>Azure<\/i><\/b> <b><i>storage account<\/i><\/b><span style=\"font-weight: 400;\"> where to upload the backups. Click <\/span><b><i>Next<\/i><\/b><span style=\"font-weight: 400;\"> to the summary tab when done.<\/span><\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-78173\" src=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Online-database-migration-activity-Configure-migration-settings.png\" alt=\"Online database migration activity - Configure migration settings\" width=\"469\" height=\"512\" srcset=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Online-database-migration-activity-Configure-migration-settings.png 469w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Online-database-migration-activity-Configure-migration-settings-275x300.png 275w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Online-database-migration-activity-Configure-migration-settings-385x420.png 385w\" sizes=\"(max-width: 469px) 100vw, 469px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">F. On the summary tab, type the <\/span><b><i>Name<\/i><\/b><span style=\"font-weight: 400;\"> of the online migration activity and finally start the migration.<\/span><br \/>\n<img decoding=\"async\" class=\"aligncenter size-full wp-image-78174\" src=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Online-database-migration-activity-summary.png\" alt=\"Online database migration activity - summary\" width=\"767\" height=\"846\" srcset=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Online-database-migration-activity-summary.png 767w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Online-database-migration-activity-summary-272x300.png 272w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Online-database-migration-activity-summary-381x420.png 381w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Online-database-migration-activity-summary-640x706.png 640w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Online-database-migration-activity-summary-681x751.png 681w\" sizes=\"(max-width: 767px) 100vw, 767px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">G. Once the migration starts and completes, the databases will remain in a <\/span><b>Log shipping state<\/b><span style=\"font-weight: 400;\">. This means you\u2019ll have two functional databases with updated data both on-prem and in the Azure cloud.<\/span><\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-78175\" src=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Online-database-migration-activity-Log-shipping-state.png\" alt=\"Online database migration activity - Log shipping state\" width=\"512\" height=\"264\" srcset=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Online-database-migration-activity-Log-shipping-state.png 512w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Online-database-migration-activity-Log-shipping-state-300x155.png 300w\" sizes=\"(max-width: 512px) 100vw, 512px\" \/><span style=\"font-weight: 400;\">H. To perform a complete <\/span><b>cutover migration<\/b><span style=\"font-weight: 400;\"> to Azure cloud, click on the Database name in the database migration activity, and click on the <\/span><b><i>Start<\/i><\/b> <b><i>Cutover <\/i><\/b><span style=\"font-weight: 400;\">button.<\/span><\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-78176\" src=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Online-database-migration-activity-star-cutover.png\" alt=\"Online database migration activity - start cutover\" width=\"1102\" height=\"537\" srcset=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Online-database-migration-activity-star-cutover.png 1102w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Online-database-migration-activity-star-cutover-300x146.png 300w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Online-database-migration-activity-star-cutover-1024x499.png 1024w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Online-database-migration-activity-star-cutover-768x374.png 768w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Online-database-migration-activity-star-cutover-862x420.png 862w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Online-database-migration-activity-star-cutover-640x312.png 640w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Online-database-migration-activity-star-cutover-681x332.png 681w\" sizes=\"(max-width: 1102px) 100vw, 1102px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">I. Once done, <\/span><b><i>Confirm <\/i><\/b><span style=\"font-weight: 400;\">and<\/span><b><i> Apply<\/i><\/b><span style=\"font-weight: 400;\"> the cutover migration.<\/span><\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-78178\" src=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Online-database-migration-activity-complete-cutover.png\" alt=\"Online database migration activity - complete cutover\" width=\"491\" height=\"512\" srcset=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Online-database-migration-activity-complete-cutover.png 491w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Online-database-migration-activity-complete-cutover-288x300.png 288w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Online-database-migration-activity-complete-cutover-403x420.png 403w\" sizes=\"(max-width: 491px) 100vw, 491px\" \/><img decoding=\"async\" class=\"aligncenter size-full wp-image-78179\" src=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Online-database-migration-activity-complete-cutover-1.png\" alt=\"Online database migration activity - complete cutover 1\" width=\"393\" height=\"512\" srcset=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Online-database-migration-activity-complete-cutover-1.png 393w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Online-database-migration-activity-complete-cutover-1-230x300.png 230w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Online-database-migration-activity-complete-cutover-1-322x420.png 322w\" sizes=\"(max-width: 393px) 100vw, 393px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">J. To confirm our new database in the Azure SQL Managed Instance, select your <\/span><b><i>Managed instance service<\/i><\/b><span style=\"font-weight: 400;\"> and look for the database that we just migrated.<\/span><\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-78180\" src=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Online-database-migration-activity-Managed-instance-service.png\" alt=\"Online database migration activity - Managed instance service\" width=\"512\" height=\"337\" srcset=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Online-database-migration-activity-Managed-instance-service.png 512w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Online-database-migration-activity-Managed-instance-service-300x197.png 300w\" sizes=\"(max-width: 512px) 100vw, 512px\" \/><\/p>\n<h4><b>Step 3:<\/b><span style=\"font-weight: 400;\"> Start the offline database migration activity (<\/span><b>Option &#8211; 2<\/b><span style=\"font-weight: 400;\">).<\/span><\/h4>\n<p><span style=\"font-weight: 400;\">A. Access your previously created migration project and select a new <\/span><b><i>Offline data migration<\/i><\/b> <span style=\"font-weight: 400;\">activity. You can also create a new migration project. In this example, we will reuse an existing project to achieve the same goal.<\/span><\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-78181\" src=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/offline-database-migration.png\" alt=\"offline database migration\" width=\"947\" height=\"525\" srcset=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/offline-database-migration.png 947w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/offline-database-migration-300x166.png 300w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/offline-database-migration-768x426.png 768w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/offline-database-migration-758x420.png 758w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/offline-database-migration-640x355.png 640w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/offline-database-migration-681x378.png 681w\" sizes=\"(max-width: 947px) 100vw, 947px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">B. Like the online migration, Insert the source SQL server <\/span><b><i>IP address<\/i><\/b><span style=\"font-weight: 400;\">, select <\/span><b><i>Windows Authentication,<\/i><\/b><span style=\"font-weight: 400;\"> and insert the <\/span><b><i>User name <\/i><\/b><span style=\"font-weight: 400;\">and<\/span><b><i> password <\/i><\/b><span style=\"font-weight: 400;\">for the source SQL Server<\/span><i><span style=\"font-weight: 400;\">.<br \/>\n<\/span><\/i><span style=\"font-weight: 400;\">Also, make sure to check both <\/span><b><i>Connection properties<\/i><\/b><span style=\"font-weight: 400;\"> checkboxes before clicking <\/span><b><i>Next<\/i><\/b><span style=\"font-weight: 400;\">.<\/span><\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-78182\" src=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/offline-database-migration-connection-properties.png\" alt=\"offline database migration - connection properties\" width=\"471\" height=\"512\" srcset=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/offline-database-migration-connection-properties.png 471w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/offline-database-migration-connection-properties-276x300.png 276w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/offline-database-migration-connection-properties-386x420.png 386w\" sizes=\"(max-width: 471px) 100vw, 471px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"font-weight: 400;\">C. The next section of the offline migration activity creation is different from the online migration type. Insert the Azure SQL-managed instance\u2019s <\/span><b><i>Target server name<\/i><\/b><span style=\"font-weight: 400;\">, set the <\/span><b><i>Authentication type<\/i><\/b><span style=\"font-weight: 400;\"> to <\/span><b>SQL Authentication<\/b><span style=\"font-weight: 400;\">, and enter the <\/span><b><i>Username <\/i><\/b><span style=\"font-weight: 400;\">and<\/span><b><i> Password<\/i><\/b><span style=\"font-weight: 400;\">. Click <\/span><b><i>Next<\/i><\/b><span style=\"font-weight: 400;\">.<\/span><\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-78183\" src=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/offline-database-migration-1.png\" alt=\"offline database migration select target\" width=\"464\" height=\"512\" srcset=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/offline-database-migration-1.png 464w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/offline-database-migration-1-272x300.png 272w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/offline-database-migration-1-381x420.png 381w\" sizes=\"(max-width: 464px) 100vw, 464px\" \/><span style=\"font-weight: 400;\">D. On the next tab, select the database(s) to migrate offline and click <\/span><b><i>Next<\/i><\/b><span style=\"font-weight: 400;\">.<\/span><\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-78185\" src=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/offline-database-migration-select-database.png\" alt=\"offline database migration - select database\" width=\"478\" height=\"512\" srcset=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/offline-database-migration-select-database.png 478w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/offline-database-migration-select-database-280x300.png 280w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/offline-database-migration-select-database-392x420.png 392w\" sizes=\"(max-width: 478px) 100vw, 478px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">E. Select the database logins to migrate with the database from the source Microsoft SQL Server and click <\/span><b><i>Next<\/i><\/b><span style=\"font-weight: 400;\">.<\/span><\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-78186\" src=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Offline-database-migration-select-login.png\" alt=\"Offline database migration - select login\" width=\"792\" height=\"841\" srcset=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Offline-database-migration-select-login.png 792w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Offline-database-migration-select-login-283x300.png 283w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Offline-database-migration-select-login-768x816.png 768w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Offline-database-migration-select-login-396x420.png 396w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Offline-database-migration-select-login-640x680.png 640w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Offline-database-migration-select-login-681x723.png 681w\" sizes=\"(max-width: 792px) 100vw, 792px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">F. On the migration settings tab, choose the <\/span><b><i>Backup option<\/i><\/b><span style=\"font-weight: 400;\">, type the <\/span><b><i>Network share<\/i><\/b><span style=\"font-weight: 400;\"> containing the database backups, type the <\/span><b><i>Windows user<\/i><\/b> <span style=\"font-weight: 400;\">and <\/span><b><i>Password<\/i><\/b><span style=\"font-weight: 400;\"> with privileges over the share, and the<\/span> <b><i>Azure storage account<\/i><\/b><span style=\"font-weight: 400;\"> to upload the databases. Click <\/span><b><i>Next<\/i><\/b><span style=\"font-weight: 400;\">.<\/span><\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-78187\" src=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/offline-database-migration-configure-migration-settings.png\" alt=\"offline database migration - configure migration settings\" width=\"468\" height=\"512\" srcset=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/offline-database-migration-configure-migration-settings.png 468w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/offline-database-migration-configure-migration-settings-274x300.png 274w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/offline-database-migration-configure-migration-settings-384x420.png 384w\" sizes=\"(max-width: 468px) 100vw, 468px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">G. Ensure every configuration is correct on the summary page, type the <\/span><b><i>migration activity name<\/i><\/b><span style=\"font-weight: 400;\"> and click <\/span><b><i>Start migration<\/i><\/b><span style=\"font-weight: 400;\">.<\/span><\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-78188\" src=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/offline-database-migration-summary.png\" alt=\"offline database migration - summary\" width=\"479\" height=\"512\" srcset=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/offline-database-migration-summary.png 479w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/offline-database-migration-summary-281x300.png 281w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/offline-database-migration-summary-393x420.png 393w\" sizes=\"(max-width: 479px) 100vw, 479px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">H. Check the screen pop-up showing the status of the offline migration.<\/span><\/p>\n<p><span style=\"font-weight: 400;\"><img decoding=\"async\" class=\"aligncenter size-full wp-image-78189\" src=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/offline-database-migration-status.png\" alt=\"offline database migration - status\" width=\"512\" height=\"314\" srcset=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/offline-database-migration-status.png 512w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/offline-database-migration-status-300x184.png 300w\" sizes=\"(max-width: 512px) 100vw, 512px\" \/>I. <\/span><span style=\"font-weight: 400;\">Once the migration is complete, we shall see the status as <\/span><b><i>Completed<\/i><\/b><span style=\"font-weight: 400;\"> on the screen.<\/span><\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-78190\" src=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/offline-database-migration-status-completed.png\" alt=\"offline database migration - status completed\" width=\"512\" height=\"262\" srcset=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/offline-database-migration-status-completed.png 512w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/offline-database-migration-status-completed-300x154.png 300w\" sizes=\"(max-width: 512px) 100vw, 512px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">J. You can now check to confirm the status of the new database on the managed instance.<\/span><\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-78191\" src=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/offline-database-migration-managed-instance.png\" alt=\"offline database migration - managed instance\" width=\"512\" height=\"276\" srcset=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/offline-database-migration-managed-instance.png 512w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/offline-database-migration-managed-instance-300x162.png 300w\" sizes=\"(max-width: 512px) 100vw, 512px\" \/><br \/>\n<span style=\"font-weight: 400;\">Well done! We have completed migrating two on-prem Microsoft SQL Server databases to the Azure cloud using both the <\/span><b><i>online<\/i><\/b><span style=\"font-weight: 400;\"> and <\/span><b><i>offline<\/i><\/b> <span style=\"font-weight: 400;\">migration methods.<\/span><\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-78192\" src=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Microsoft-SQL-Server-databases-online-and-offline-migration.png\" alt=\"Microsoft SQL Server databases - online and offline migration\" width=\"512\" height=\"262\" srcset=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Microsoft-SQL-Server-databases-online-and-offline-migration.png 512w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Microsoft-SQL-Server-databases-online-and-offline-migration-300x154.png 300w\" sizes=\"(max-width: 512px) 100vw, 512px\" \/><\/p>\n<blockquote><p>Not sure about which microsoft azure certification to get? Try our annual SUBSCRIPTION and learn unlimited! Click <a href=\"https:\/\/www.whizlabs.com\/subscription\/\">here<\/a> to know more<\/p><\/blockquote>\n<h2><span class=\"ez-toc-section\" id=\"Troubleshooting_Common_Migration_Issues\"><\/span><span style=\"font-weight: 400;\">Troubleshooting Common Migration Issues<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><b>Issue 1<\/b><span style=\"font-weight: 400;\">: The Azure SQL-managed instance cannot connect to the on-prem Microsoft SQL Server.<\/span><\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-78193\" src=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/The-Azure-SQL-managed-instance-cannot-connect-to-the-on-prem-Microsoft-SQL-Server.png\" alt=\"The Azure SQL-managed instance cannot connect to the on-prem Microsoft SQL Server\" width=\"506\" height=\"471\" srcset=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/The-Azure-SQL-managed-instance-cannot-connect-to-the-on-prem-Microsoft-SQL-Server.png 506w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/The-Azure-SQL-managed-instance-cannot-connect-to-the-on-prem-Microsoft-SQL-Server-300x279.png 300w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/The-Azure-SQL-managed-instance-cannot-connect-to-the-on-prem-Microsoft-SQL-Server-451x420.png 451w\" sizes=\"(max-width: 506px) 100vw, 506px\" \/><\/p>\n<p><b>Resolution<\/b><span style=\"font-weight: 400;\">: Ensure VPN connectivity between the Azure SQL-managed instance and the on-prem Microsoft SQL Server. Also, make sure that SQL Server engine <\/span><b><i>port 1433<\/i><\/b><span style=\"font-weight: 400;\"> is open.<\/span><\/p>\n<p><b>Issue 2<\/b><span style=\"font-weight: 400;\">: Failed to authenticate the service principal during online database migration.<\/span><\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-78194\" src=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Failed-to-authenticate-the-service-principal-during-online-database-migration.png\" alt=\"Failed to authenticate the service principal during online database migration\" width=\"432\" height=\"351\" srcset=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Failed-to-authenticate-the-service-principal-during-online-database-migration.png 432w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Failed-to-authenticate-the-service-principal-during-online-database-migration-300x244.png 300w\" sizes=\"(max-width: 432px) 100vw, 432px\" \/><\/p>\n<p><b>Resolution<\/b><span style=\"font-weight: 400;\">: Ensure that the <\/span><b><i>Application ID<\/i><\/b><span style=\"font-weight: 400;\"> and <\/span><b><i>Client secret<\/i><\/b><span style=\"font-weight: 400;\"> used within the online migration settings are correct and the <\/span><b><i>Service Principal<\/i><\/b><span style=\"font-weight: 400;\"> has contributor access over the subscription.<\/span><\/p>\n<p><b>Issue 3<\/b><span style=\"font-weight: 400;\">: The data migration and on-prem Microsoft SQL Server service account cannot access the shared backups folder.<\/span><\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-78195\" src=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/The-data-migration-and-on-prem-Microsoft-SQL-Server-service-account-cannot-access-the-shared-backups-folder.png\" alt=\"The data migration and on-prem Microsoft SQL Server service account cannot access the shared backups folder\" width=\"432\" height=\"297\" srcset=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/The-data-migration-and-on-prem-Microsoft-SQL-Server-service-account-cannot-access-the-shared-backups-folder.png 432w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/The-data-migration-and-on-prem-Microsoft-SQL-Server-service-account-cannot-access-the-shared-backups-folder-300x206.png 300w\" sizes=\"(max-width: 432px) 100vw, 432px\" \/><\/p>\n<p><b>Resolution<\/b><span style=\"font-weight: 400;\">: Ensure that the Windows user account used in creating the migration activity has <\/span><i><span style=\"font-weight: 400;\">read and write<\/span><\/i><span style=\"font-weight: 400;\"> permissions over the shared folder. Also, ensure that the Microsoft SQL Server service account has <\/span><i><span style=\"font-weight: 400;\">read <\/span><\/i><span style=\"font-weight: 400;\">and<\/span><i><span style=\"font-weight: 400;\"> write<\/span><\/i><span style=\"font-weight: 400;\"> permissions onto the shared folder.<\/span><\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-78196\" src=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/The-data-migration-and-on-prem-Microsoft-SQL-Server-service-account-cannot-access-the-shared-backups-folder-1.png\" alt=\"The data migration and on-prem Microsoft SQL Server service account cannot access the shared backups folder 1\" width=\"512\" height=\"358\" srcset=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/The-data-migration-and-on-prem-Microsoft-SQL-Server-service-account-cannot-access-the-shared-backups-folder-1.png 512w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/The-data-migration-and-on-prem-Microsoft-SQL-Server-service-account-cannot-access-the-shared-backups-folder-1-300x210.png 300w\" sizes=\"(max-width: 512px) 100vw, 512px\" \/><\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-78197\" src=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/The-data-migration-and-on-prem-Microsoft-SQL-Server-service-account-cannot-access-the-shared-backups-folder-2.png.png\" alt=\"The data migration and on-prem Microsoft SQL Server service account cannot access the shared backups folder 2.png\" width=\"397\" height=\"512\" srcset=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/The-data-migration-and-on-prem-Microsoft-SQL-Server-service-account-cannot-access-the-shared-backups-folder-2.png.png 397w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/The-data-migration-and-on-prem-Microsoft-SQL-Server-service-account-cannot-access-the-shared-backups-folder-2.png-233x300.png 233w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/The-data-migration-and-on-prem-Microsoft-SQL-Server-service-account-cannot-access-the-shared-backups-folder-2.png-326x420.png 326w\" sizes=\"(max-width: 397px) 100vw, 397px\" \/><\/p>\n<p><b>Issue 4<\/b><span style=\"font-weight: 400;\">: Database migration error or No valid full backup found.<\/span><\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-78198\" src=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Database-migration-error-or-No-valid-full-backup-found.png\" alt=\"Database migration error or No valid full backup found\" width=\"435\" height=\"231\" srcset=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Database-migration-error-or-No-valid-full-backup-found.png 435w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Database-migration-error-or-No-valid-full-backup-found-300x160.png 300w\" sizes=\"(max-width: 435px) 100vw, 435px\" \/><\/p>\n<p><b>Resolution<\/b><span style=\"font-weight: 400;\">: Ensure that you have <\/span><b><i>Full backups<\/i><\/b><span style=\"font-weight: 400;\">, and not <\/span><b><i>Differential <\/i><\/b><span style=\"font-weight: 400;\">or<\/span><b><i> Incremental backups <\/i><\/b><span style=\"font-weight: 400;\">enabled for the backups shared folder.<\/span><\/p>\n<p><b>Issue 5<\/b><span style=\"font-weight: 400;\">: Appended backup set error.<\/span><\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-78199\" src=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Appended-backup-set-error.png\" alt=\"Appended backup set error\" width=\"432\" height=\"408\" srcset=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Appended-backup-set-error.png 432w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Appended-backup-set-error-300x283.png 300w\" sizes=\"(max-width: 432px) 100vw, 432px\" \/><\/p>\n<p><b>Resolution<\/b><span style=\"font-weight: 400;\">: The Data migration service doesn\u2019t accept appended backup sets. Use the <\/span><b><i>Overwrite<\/i><\/b> <b><i>backup sets<\/i><\/b><span style=\"font-weight: 400;\"> option when creating backups. If you are using Microsoft SQL Server maintenance plans, add the options to the maintenance steps.<\/span><\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-78200\" src=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Appended-backup-set-error-resolution.png\" alt=\"Appended backup set error - resolution\" width=\"512\" height=\"211\" srcset=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Appended-backup-set-error-resolution.png 512w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Appended-backup-set-error-resolution-300x124.png 300w\" sizes=\"(max-width: 512px) 100vw, 512px\" \/><\/p>\n<p><b>Issue 6<\/b><span style=\"font-weight: 400;\">: Disabled checksum during the creation of database backups.<\/span><\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-78201\" src=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Disabled-checksum-during-the-creation-of-database-backups.png\" alt=\"Disabled checksum during the creation of database backups\" width=\"432\" height=\"427\" srcset=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Disabled-checksum-during-the-creation-of-database-backups.png 432w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Disabled-checksum-during-the-creation-of-database-backups-300x297.png 300w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Disabled-checksum-during-the-creation-of-database-backups-425x420.png 425w\" sizes=\"(max-width: 432px) 100vw, 432px\" \/><\/p>\n<p><b>Resolution<\/b><span style=\"font-weight: 400;\">: The Data migration service requires <\/span><b><i>enabled<\/i><\/b> <b><i>checksum<\/i><\/b><span style=\"font-weight: 400;\"> before <\/span><b><i>Writing to media <\/i><\/b><span style=\"font-weight: 400;\">option on all your database backups. Also, make sure to set this option if you are using maintenance plans or any other SQL Server database backup option that you\u2019re using.<\/span><\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-78202\" src=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Disabled-checksum-during-the-creation-of-database-backups-resolution.png\" alt=\"Disabled checksum during the creation of database backups resolution\" width=\"929\" height=\"471\" srcset=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Disabled-checksum-during-the-creation-of-database-backups-resolution.png 929w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Disabled-checksum-during-the-creation-of-database-backups-resolution-300x152.png 300w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Disabled-checksum-during-the-creation-of-database-backups-resolution-768x389.png 768w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Disabled-checksum-during-the-creation-of-database-backups-resolution-828x420.png 828w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Disabled-checksum-during-the-creation-of-database-backups-resolution-640x324.png 640w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/Disabled-checksum-during-the-creation-of-database-backups-resolution-681x345.png 681w\" sizes=\"(max-width: 929px) 100vw, 929px\" \/><\/p>\n<h2><\/h2>\n<blockquote>\n<h2><span class=\"ez-toc-section\" id=\"Checkout_Whizlabs_Microsoft_Azure_Certification_courses_here\"><\/span>Checkout Whizlabs Microsoft Azure Certification courses <a href=\"https:\/\/www.whizlabs.com\/microsoft-azure-certification-training-courses\/\">here<\/a>!<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<\/blockquote>\n<h2><span class=\"ez-toc-section\" id=\"Conclusion\"><\/span><span style=\"font-weight: 400;\">Conclusion<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">With businesses looking towards leveraging the cloud to gain a competitive advantage, moving your Microsoft SQL Server database to the Azure cloud offers unparalleled benefits. High availability with 99.99% SLA, automated patching, automated backups and retention, artificial intelligence-driven query performance, and threat detection are just a few of the reasons teams should migrate their databases to the Azure cloud.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Not to say, moving your Microsoft SQL Servers\/databases reduces the CAPEX (Capital expenditures) and OPEX (Operating expenditures) on Server hardware and software licenses. This lets you <\/span><i><span style=\"font-weight: 400;\">lift and shift<\/span><\/i><span style=\"font-weight: 400;\"> your databases and let Microsoft handle the rest.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Azure SQL is a family of cloud relational databases that Microsoft offers as a service on Azure. These databases are powered by a SQL Server Engine which consistently goes through monumental updates and improvements by Microsoft to ensure enhanced efficiency.\u00a0 While Microsoft continues to support its on-prem setup of the Microsoft SQL Server product, more capabilities and extended support are provided on the cloud, delivering solutions that leverage the ever-growing data demands in today\u2019s information age. Today, Microsoft has three offerings that make up the entire Azure SQL family, which are:\u00a0 SQL Server on Azure Virtual Machines,\u00a0 Azure SQL Managed [&hellip;]<\/p>\n","protected":false},"author":169,"featured_media":78159,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_uag_custom_page_level_css":"","site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[15],"tags":[361,4037,4036,4039,4034,4035,4040,4041,4038],"class_list":["post-78119","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-microsoft-azure","tag-azure-cloud","tag-data-migration-tools","tag-migrate-on-prem-sql-server-db-to-azure-cloud","tag-migration-quick-tips","tag-offline-migration","tag-online-migration","tag-quick-tips","tag-server-dp-to-azure-cloud","tag-sql-server-engine"],"uagb_featured_image_src":{"full":["https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/How-to-Migrate-Your-On-Prem-SQL-Server-DB-to-Azure-Cloud.png",600,315,false],"thumbnail":["https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/How-to-Migrate-Your-On-Prem-SQL-Server-DB-to-Azure-Cloud-150x150.png",150,150,true],"medium":["https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/How-to-Migrate-Your-On-Prem-SQL-Server-DB-to-Azure-Cloud-300x158.png",300,158,true],"medium_large":["https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/How-to-Migrate-Your-On-Prem-SQL-Server-DB-to-Azure-Cloud.png",600,315,false],"large":["https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/How-to-Migrate-Your-On-Prem-SQL-Server-DB-to-Azure-Cloud.png",600,315,false],"1536x1536":["https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/How-to-Migrate-Your-On-Prem-SQL-Server-DB-to-Azure-Cloud.png",600,315,false],"2048x2048":["https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/How-to-Migrate-Your-On-Prem-SQL-Server-DB-to-Azure-Cloud.png",600,315,false],"profile_24":["https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/How-to-Migrate-Your-On-Prem-SQL-Server-DB-to-Azure-Cloud.png",24,13,false],"profile_48":["https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/How-to-Migrate-Your-On-Prem-SQL-Server-DB-to-Azure-Cloud.png",48,25,false],"profile_96":["https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/How-to-Migrate-Your-On-Prem-SQL-Server-DB-to-Azure-Cloud.png",96,50,false],"profile_150":["https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/How-to-Migrate-Your-On-Prem-SQL-Server-DB-to-Azure-Cloud.png",150,79,false],"profile_300":["https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/How-to-Migrate-Your-On-Prem-SQL-Server-DB-to-Azure-Cloud.png",300,158,false],"tptn_thumbnail":["https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/How-to-Migrate-Your-On-Prem-SQL-Server-DB-to-Azure-Cloud-250x250.png",250,250,true],"web-stories-poster-portrait":["https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/How-to-Migrate-Your-On-Prem-SQL-Server-DB-to-Azure-Cloud.png",600,315,false],"web-stories-publisher-logo":["https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/How-to-Migrate-Your-On-Prem-SQL-Server-DB-to-Azure-Cloud.png",96,50,false],"web-stories-thumbnail":["https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/04\/How-to-Migrate-Your-On-Prem-SQL-Server-DB-to-Azure-Cloud.png",150,79,false]},"uagb_author_info":{"display_name":"Girdharee Saran","author_link":"https:\/\/www.whizlabs.com\/blog\/author\/girdharee\/"},"uagb_comment_info":21,"uagb_excerpt":"Azure SQL is a family of cloud relational databases that Microsoft offers as a service on Azure. These databases are powered by a SQL Server Engine which consistently goes through monumental updates and improvements by Microsoft to ensure enhanced efficiency.\u00a0 While Microsoft continues to support its on-prem setup of the Microsoft SQL Server product, more&hellip;","_links":{"self":[{"href":"https:\/\/www.whizlabs.com\/blog\/wp-json\/wp\/v2\/posts\/78119","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.whizlabs.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.whizlabs.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.whizlabs.com\/blog\/wp-json\/wp\/v2\/users\/169"}],"replies":[{"embeddable":true,"href":"https:\/\/www.whizlabs.com\/blog\/wp-json\/wp\/v2\/comments?post=78119"}],"version-history":[{"count":7,"href":"https:\/\/www.whizlabs.com\/blog\/wp-json\/wp\/v2\/posts\/78119\/revisions"}],"predecessor-version":[{"id":78210,"href":"https:\/\/www.whizlabs.com\/blog\/wp-json\/wp\/v2\/posts\/78119\/revisions\/78210"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.whizlabs.com\/blog\/wp-json\/wp\/v2\/media\/78159"}],"wp:attachment":[{"href":"https:\/\/www.whizlabs.com\/blog\/wp-json\/wp\/v2\/media?parent=78119"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.whizlabs.com\/blog\/wp-json\/wp\/v2\/categories?post=78119"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.whizlabs.com\/blog\/wp-json\/wp\/v2\/tags?post=78119"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}