{"id":17340,"date":"2021-10-05T11:22:43","date_gmt":"2021-10-05T05:52:43","guid":{"rendered":"http:\/\/onlineappsdba.com\/?p=17340"},"modified":"2021-10-05T11:22:43","modified_gmt":"2021-10-05T05:52:43","slug":"migrate-sql-server-to-an-azure-sql-managed-instance-online","status":"publish","type":"post","link":"https:\/\/onlineappsdba.com\/index.php\/2021\/10\/05\/migrate-sql-server-to-an-azure-sql-managed-instance-online\/","title":{"rendered":"Migrate SQL Server To an Azure SQL Managed Instance [Online]"},"content":{"rendered":"<p>In this blog, we are going to cover the steps to Migrate SQL Server To An Azure SQL Managed Instance [Online] using a database migration service (Adventureworks2016 database ) with minimal downtime and these roles are mainly performed by the database administrator.<\/p>\n<p><b data-stringify-type=\"bold\">What Is Azure SQL Managed Instance?<\/b><\/p>\n<p>SQL Managed Instance is a PaaS deployment option of Azure SQL. It gives you an instance of SQL Server but removes much of the overhead of managing a virtual machine. Most of the features available in SQL Server are available in SQL Managed Instance.<\/p>\n<p>This option is ideal for customers who want to use instance-scoped features and want to move to Azure without re-architecting their applications. (Instance-scoped features are features that are tied to an instance of SQL Server, as opposed to features that are tied to a database in an instance of SQL Server.).<\/p>\n<p><b data-stringify-type=\"bold\">What Is Database Migration Service?<\/b><\/p>\n<p>Azure Database Migration Service is a tool that helps you simplify, guide, and automate your database migration to Azure. Easily migrate your data, schema, and objects from multiple sources to the cloud at scale. It supports\u00a0 Microsoft SQL Server, MySQL, PostgreSQL, MongoDB, and Oracle migration to Azure from on-premises and other clouds.<\/p>\n<p>Want to know more about\u00a0<b data-stringify-type=\"bold\">Migrate SQL Server To an Azure SQL Managed Instance [Online]<\/b>?<\/p>\n<p>Read the blog post at <a href=\"https:\/\/k21academy.com\/microsoft-azure\/database-administrator\/migrate-sql-server-to-an-azure-sql-managed-instance-online\/?utm_source=onlineappsdba&amp;utm_medium=referral&amp;utm_campaign=dp30029_october21\" target=\"_blank\" rel=\"noopener noreferrer\"><em><strong>https:\/\/k21academy.com\/dp30029<\/strong><\/em><\/a> to learn more.<\/p>\n<p><b data-stringify-type=\"bold\">Topics, we\u2019ll cover:<\/b><\/p>\n<p>\u2022\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 What Is Azure SQL Managed Instance<br \/>\n\u2022\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 What is Database Migration Service<br \/>\n\u2022\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Register the Azure DataMigration resource provider.<br \/>\n\u2022\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Create an instance of Azure Database Migration Service.<br \/>\n\u2022\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Create a migration project by using Azure Database Migration Service.<br \/>\n\u2022\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Monitor the migration.<br \/>\n\u2022\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Performing migration cutoverIf you are planning to become a Microsoft<\/p>\n<p>If you are planning to become a Microsoft Azure Database Administrator Associate, then join the FREE CLASS now at\u00a0<a href=\"https:\/\/k21academy.com\/microsoft-azure-database-training-free-class\/?utm_source=onlineappsdba&amp;utm_medium=referral&amp;utm_campaign=dp30002_october21\" target=\"_blank\" rel=\"noopener noreferrer\"><em><strong>https:\/\/k21academy.com\/ dp30002<\/strong><\/em><\/a>\u00a0.<\/p>\n<p><a href=\"https:\/\/k21academy.com\/microsoft-azure-database-training-free-class\/?utm_source=onlineappsdba&amp;utm_medium=referral&amp;utm_campaign=dp30002_october21\" target=\"_blank\" rel=\"noopener noreferrer\"><img decoding=\"async\" class=\"aligncenter\" src=\"https:\/\/k21academy.com\/wp-content\/uploads\/2021\/06\/DBAdmin_CU.gif\" alt=\"DBAdmin_CU\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In this blog, we are going to cover the steps to Migrate SQL Server To An Azure SQL Managed Instance [&hellip;]<\/p>\n","protected":false},"author":115,"featured_media":17341,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"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-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":"","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-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":"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":""},"mobile":{"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":""}},"footnotes":""},"categories":[568,540],"tags":[],"class_list":["post-17340","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-dp-300","category-microsoft-azure"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Migrate SQL Server to an Azure sql server managed instance online<\/title>\n<meta name=\"description\" content=\"In this blog, we are going to cover the steps to Migrate SQL Server To An Azure SQL Managed Instance [Online] using a database migration service.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/onlineappsdba.com\/index.php\/2021\/10\/05\/migrate-sql-server-to-an-azure-sql-managed-instance-online\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Migrate SQL Server to an Azure sql server managed instance online\" \/>\n<meta property=\"og:description\" content=\"In this blog, we are going to cover the steps to Migrate SQL Server To An Azure SQL Managed Instance [Online] using a database migration service.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/onlineappsdba.com\/index.php\/2021\/10\/05\/migrate-sql-server-to-an-azure-sql-managed-instance-online\/\" \/>\n<meta property=\"article:published_time\" content=\"2021-10-05T05:52:43+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/onlineappsdba.com\/wp-content\/uploads\/2021\/10\/MigrateSQLManaged_BlogImage.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1125\" \/>\n\t<meta property=\"og:image:height\" content=\"629\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Masroof Ahmad\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Masroof Ahmad\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2021\/10\/05\/migrate-sql-server-to-an-azure-sql-managed-instance-online\/\",\"url\":\"https:\/\/onlineappsdba.com\/index.php\/2021\/10\/05\/migrate-sql-server-to-an-azure-sql-managed-instance-online\/\",\"name\":\"Migrate SQL Server to an Azure sql server managed instance online\",\"isPartOf\":{\"@id\":\"https:\/\/onlineappsdba.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2021\/10\/05\/migrate-sql-server-to-an-azure-sql-managed-instance-online\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2021\/10\/05\/migrate-sql-server-to-an-azure-sql-managed-instance-online\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/onlineappsdba.com\/wp-content\/uploads\/2021\/10\/MigrateSQLManaged_BlogImage.png\",\"datePublished\":\"2021-10-05T05:52:43+00:00\",\"author\":{\"@id\":\"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb\"},\"description\":\"In this blog, we are going to cover the steps to Migrate SQL Server To An Azure SQL Managed Instance [Online] using a database migration service.\",\"breadcrumb\":{\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2021\/10\/05\/migrate-sql-server-to-an-azure-sql-managed-instance-online\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/onlineappsdba.com\/index.php\/2021\/10\/05\/migrate-sql-server-to-an-azure-sql-managed-instance-online\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2021\/10\/05\/migrate-sql-server-to-an-azure-sql-managed-instance-online\/#primaryimage\",\"url\":\"https:\/\/onlineappsdba.com\/wp-content\/uploads\/2021\/10\/MigrateSQLManaged_BlogImage.png\",\"contentUrl\":\"https:\/\/onlineappsdba.com\/wp-content\/uploads\/2021\/10\/MigrateSQLManaged_BlogImage.png\",\"width\":1125,\"height\":629,\"caption\":\"Migrate SQL\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2021\/10\/05\/migrate-sql-server-to-an-azure-sql-managed-instance-online\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/onlineappsdba.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Migrate SQL Server To an Azure SQL Managed Instance [Online]\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/onlineappsdba.com\/#website\",\"url\":\"https:\/\/onlineappsdba.com\/\",\"name\":\"\",\"description\":\"Oracle Implementation &amp; Training Experts\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/onlineappsdba.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb\",\"name\":\"Masroof Ahmad\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/onlineappsdba.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/10f9db7bdbbd7f9ccfbe9b2d208e5978fc28315e9c704383e639a926ea0fce5f?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/10f9db7bdbbd7f9ccfbe9b2d208e5978fc28315e9c704383e639a926ea0fce5f?s=96&d=mm&r=g\",\"caption\":\"Masroof Ahmad\"},\"url\":\"https:\/\/onlineappsdba.com\/index.php\/author\/masroof\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Migrate SQL Server to an Azure sql server managed instance online","description":"In this blog, we are going to cover the steps to Migrate SQL Server To An Azure SQL Managed Instance [Online] using a database migration service.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/onlineappsdba.com\/index.php\/2021\/10\/05\/migrate-sql-server-to-an-azure-sql-managed-instance-online\/","og_locale":"en_US","og_type":"article","og_title":"Migrate SQL Server to an Azure sql server managed instance online","og_description":"In this blog, we are going to cover the steps to Migrate SQL Server To An Azure SQL Managed Instance [Online] using a database migration service.","og_url":"https:\/\/onlineappsdba.com\/index.php\/2021\/10\/05\/migrate-sql-server-to-an-azure-sql-managed-instance-online\/","article_published_time":"2021-10-05T05:52:43+00:00","og_image":[{"width":1125,"height":629,"url":"https:\/\/onlineappsdba.com\/wp-content\/uploads\/2021\/10\/MigrateSQLManaged_BlogImage.png","type":"image\/png"}],"author":"Masroof Ahmad","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Masroof Ahmad","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/onlineappsdba.com\/index.php\/2021\/10\/05\/migrate-sql-server-to-an-azure-sql-managed-instance-online\/","url":"https:\/\/onlineappsdba.com\/index.php\/2021\/10\/05\/migrate-sql-server-to-an-azure-sql-managed-instance-online\/","name":"Migrate SQL Server to an Azure sql server managed instance online","isPartOf":{"@id":"https:\/\/onlineappsdba.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/onlineappsdba.com\/index.php\/2021\/10\/05\/migrate-sql-server-to-an-azure-sql-managed-instance-online\/#primaryimage"},"image":{"@id":"https:\/\/onlineappsdba.com\/index.php\/2021\/10\/05\/migrate-sql-server-to-an-azure-sql-managed-instance-online\/#primaryimage"},"thumbnailUrl":"https:\/\/onlineappsdba.com\/wp-content\/uploads\/2021\/10\/MigrateSQLManaged_BlogImage.png","datePublished":"2021-10-05T05:52:43+00:00","author":{"@id":"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb"},"description":"In this blog, we are going to cover the steps to Migrate SQL Server To An Azure SQL Managed Instance [Online] using a database migration service.","breadcrumb":{"@id":"https:\/\/onlineappsdba.com\/index.php\/2021\/10\/05\/migrate-sql-server-to-an-azure-sql-managed-instance-online\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/onlineappsdba.com\/index.php\/2021\/10\/05\/migrate-sql-server-to-an-azure-sql-managed-instance-online\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/onlineappsdba.com\/index.php\/2021\/10\/05\/migrate-sql-server-to-an-azure-sql-managed-instance-online\/#primaryimage","url":"https:\/\/onlineappsdba.com\/wp-content\/uploads\/2021\/10\/MigrateSQLManaged_BlogImage.png","contentUrl":"https:\/\/onlineappsdba.com\/wp-content\/uploads\/2021\/10\/MigrateSQLManaged_BlogImage.png","width":1125,"height":629,"caption":"Migrate SQL"},{"@type":"BreadcrumbList","@id":"https:\/\/onlineappsdba.com\/index.php\/2021\/10\/05\/migrate-sql-server-to-an-azure-sql-managed-instance-online\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/onlineappsdba.com\/"},{"@type":"ListItem","position":2,"name":"Migrate SQL Server To an Azure SQL Managed Instance [Online]"}]},{"@type":"WebSite","@id":"https:\/\/onlineappsdba.com\/#website","url":"https:\/\/onlineappsdba.com\/","name":"","description":"Oracle Implementation &amp; Training Experts","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/onlineappsdba.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb","name":"Masroof Ahmad","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/onlineappsdba.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/10f9db7bdbbd7f9ccfbe9b2d208e5978fc28315e9c704383e639a926ea0fce5f?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/10f9db7bdbbd7f9ccfbe9b2d208e5978fc28315e9c704383e639a926ea0fce5f?s=96&d=mm&r=g","caption":"Masroof Ahmad"},"url":"https:\/\/onlineappsdba.com\/index.php\/author\/masroof\/"}]}},"_links":{"self":[{"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/posts\/17340","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/users\/115"}],"replies":[{"embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/comments?post=17340"}],"version-history":[{"count":0,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/posts\/17340\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/media\/17341"}],"wp:attachment":[{"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/media?parent=17340"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/categories?post=17340"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/tags?post=17340"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}