{"id":16856,"date":"2021-08-02T18:10:29","date_gmt":"2021-08-02T12:40:29","guid":{"rendered":"http:\/\/onlineappsdba.com\/?p=16856"},"modified":"2021-08-02T18:10:29","modified_gmt":"2021-08-02T12:40:29","slug":"migrate-sql-server-to-azure-sql-database","status":"publish","type":"post","link":"https:\/\/onlineappsdba.com\/index.php\/2021\/08\/02\/migrate-sql-server-to-azure-sql-database\/","title":{"rendered":"Migrate SQL Server To Azure SQL Database"},"content":{"rendered":"<p>\ud83d\udc49 Azure Database Administrator is responsible to implements and manages the operational aspects of cloud-native and hybrid data platform solutions built on Azure Data Services and SQL Server. The Azure Database administrator uses a variety of methods and tools to perform day-to-day operations, including applying knowledge of using T-SQL for administrative management purposes.<\/p>\n<p>\ud83d\udc49 The Azure Migration service can be used to perform database migration from a source onto a target. This source can vary from using SQL Server on an Azure VM, or SQL Server in an on-premises data center, or using Oracle database as the source. The target can be an Azure SQL VM, Azure SQL Database, Azure Cosmos DB. You can perform an offline migration here the application downtime will begin at the same time the migration starts and if you want to limit the downtime, you can perform an online migration.<\/p>\n<p>Want to know more about Migrate SQL Server To Azure SQL Database? Read the blog post at <a href=\"https:\/\/k21academy.com\/microsoft-azure\/database-administrator\/migrate-sql-server-to-azure-sql-database\/?utm_source=onlineappsdba&amp;utm_medium=referral&amp;utm_campaign=dp30013_august21\" target=\"_blank\" rel=\"noopener noreferrer\"><strong><em>https:\/\/k21academy.com\/dp30013<\/em><\/strong> <\/a>to learn more.<\/p>\n<p>Topics, we\u2019ll cover:<\/p>\n<p>1. Azure Database Migration<\/p>\n<p>2. Types of Migration in Azure<\/p>\n<p>3. Migration Assistant in Azure<\/p>\n<p>4.Hands-on to perform Offline Migration From SQL Server To Azure<\/p>\n<p>If you are planning to become a MicrosoftAzure Database Administrator Associate, then join the FREE CLASS now at <a href=\"https:\/\/k21academy.com\/microsoft-azure-database-training-free-class\/?utm_source=onlineappsdba&amp;utm_medium=referral&amp;utm_campaign=dp30002_july21\" target=\"_blank\" rel=\"noopener noreferrer\"><em><strong>https:\/\/k21academy.com\/dp30002<\/strong><\/em><\/a><\/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_july21\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-99652 size-full\" src=\"https:\/\/k21academy.com\/wp-content\/uploads\/2021\/06\/DBAdmin_CU.gif\" alt=\"DBAdmin_CU\" width=\"1470\" height=\"218\" \/><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\ud83d\udc49 Azure Database Administrator is responsible to implements and manages the operational aspects of cloud-native and hybrid data platform solutions [&hellip;]<\/p>\n","protected":false},"author":115,"featured_media":16857,"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-16856","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 Azure SQL Database | K21 Academy<\/title>\n<meta name=\"description\" content=\"This blog post will give you an overview of Migrate SQL Server to Azure SQL Database. You can use DMS to migrate the DB from a SQL Server to Azure SQL DB.\" \/>\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\/08\/02\/migrate-sql-server-to-azure-sql-database\/\" \/>\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 Azure SQL Database | K21 Academy\" \/>\n<meta property=\"og:description\" content=\"This blog post will give you an overview of Migrate SQL Server to Azure SQL Database. You can use DMS to migrate the DB from a SQL Server to Azure SQL DB.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/onlineappsdba.com\/index.php\/2021\/08\/02\/migrate-sql-server-to-azure-sql-database\/\" \/>\n<meta property=\"article:published_time\" content=\"2021-08-02T12:40:29+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/onlineappsdba.com\/wp-content\/uploads\/2021\/08\/AzureSQL_BlogImage2.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=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2021\/08\/02\/migrate-sql-server-to-azure-sql-database\/\",\"url\":\"https:\/\/onlineappsdba.com\/index.php\/2021\/08\/02\/migrate-sql-server-to-azure-sql-database\/\",\"name\":\"Migrate SQL Server to Azure SQL Database | K21 Academy\",\"isPartOf\":{\"@id\":\"https:\/\/onlineappsdba.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2021\/08\/02\/migrate-sql-server-to-azure-sql-database\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2021\/08\/02\/migrate-sql-server-to-azure-sql-database\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/onlineappsdba.com\/wp-content\/uploads\/2021\/08\/AzureSQL_BlogImage2.png\",\"datePublished\":\"2021-08-02T12:40:29+00:00\",\"author\":{\"@id\":\"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb\"},\"description\":\"This blog post will give you an overview of Migrate SQL Server to Azure SQL Database. You can use DMS to migrate the DB from a SQL Server to Azure SQL DB.\",\"breadcrumb\":{\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2021\/08\/02\/migrate-sql-server-to-azure-sql-database\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/onlineappsdba.com\/index.php\/2021\/08\/02\/migrate-sql-server-to-azure-sql-database\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2021\/08\/02\/migrate-sql-server-to-azure-sql-database\/#primaryimage\",\"url\":\"https:\/\/onlineappsdba.com\/wp-content\/uploads\/2021\/08\/AzureSQL_BlogImage2.png\",\"contentUrl\":\"https:\/\/onlineappsdba.com\/wp-content\/uploads\/2021\/08\/AzureSQL_BlogImage2.png\",\"width\":1125,\"height\":629,\"caption\":\"Azure SQL\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2021\/08\/02\/migrate-sql-server-to-azure-sql-database\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/onlineappsdba.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Migrate SQL Server To Azure SQL Database\"}]},{\"@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 Azure SQL Database | K21 Academy","description":"This blog post will give you an overview of Migrate SQL Server to Azure SQL Database. You can use DMS to migrate the DB from a SQL Server to Azure SQL DB.","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\/08\/02\/migrate-sql-server-to-azure-sql-database\/","og_locale":"en_US","og_type":"article","og_title":"Migrate SQL Server to Azure SQL Database | K21 Academy","og_description":"This blog post will give you an overview of Migrate SQL Server to Azure SQL Database. You can use DMS to migrate the DB from a SQL Server to Azure SQL DB.","og_url":"https:\/\/onlineappsdba.com\/index.php\/2021\/08\/02\/migrate-sql-server-to-azure-sql-database\/","article_published_time":"2021-08-02T12:40:29+00:00","og_image":[{"width":1125,"height":629,"url":"https:\/\/onlineappsdba.com\/wp-content\/uploads\/2021\/08\/AzureSQL_BlogImage2.png","type":"image\/png"}],"author":"Masroof Ahmad","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Masroof Ahmad","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/onlineappsdba.com\/index.php\/2021\/08\/02\/migrate-sql-server-to-azure-sql-database\/","url":"https:\/\/onlineappsdba.com\/index.php\/2021\/08\/02\/migrate-sql-server-to-azure-sql-database\/","name":"Migrate SQL Server to Azure SQL Database | K21 Academy","isPartOf":{"@id":"https:\/\/onlineappsdba.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/onlineappsdba.com\/index.php\/2021\/08\/02\/migrate-sql-server-to-azure-sql-database\/#primaryimage"},"image":{"@id":"https:\/\/onlineappsdba.com\/index.php\/2021\/08\/02\/migrate-sql-server-to-azure-sql-database\/#primaryimage"},"thumbnailUrl":"https:\/\/onlineappsdba.com\/wp-content\/uploads\/2021\/08\/AzureSQL_BlogImage2.png","datePublished":"2021-08-02T12:40:29+00:00","author":{"@id":"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb"},"description":"This blog post will give you an overview of Migrate SQL Server to Azure SQL Database. You can use DMS to migrate the DB from a SQL Server to Azure SQL DB.","breadcrumb":{"@id":"https:\/\/onlineappsdba.com\/index.php\/2021\/08\/02\/migrate-sql-server-to-azure-sql-database\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/onlineappsdba.com\/index.php\/2021\/08\/02\/migrate-sql-server-to-azure-sql-database\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/onlineappsdba.com\/index.php\/2021\/08\/02\/migrate-sql-server-to-azure-sql-database\/#primaryimage","url":"https:\/\/onlineappsdba.com\/wp-content\/uploads\/2021\/08\/AzureSQL_BlogImage2.png","contentUrl":"https:\/\/onlineappsdba.com\/wp-content\/uploads\/2021\/08\/AzureSQL_BlogImage2.png","width":1125,"height":629,"caption":"Azure SQL"},{"@type":"BreadcrumbList","@id":"https:\/\/onlineappsdba.com\/index.php\/2021\/08\/02\/migrate-sql-server-to-azure-sql-database\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/onlineappsdba.com\/"},{"@type":"ListItem","position":2,"name":"Migrate SQL Server To Azure SQL Database"}]},{"@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\/16856","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=16856"}],"version-history":[{"count":0,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/posts\/16856\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/media\/16857"}],"wp:attachment":[{"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/media?parent=16856"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/categories?post=16856"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/tags?post=16856"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}