{"id":31782,"date":"2020-07-28T10:00:52","date_gmt":"2020-07-28T17:00:52","guid":{"rendered":""},"modified":"2024-01-08T22:22:37","modified_gmt":"2024-01-09T06:22:37","slug":"more-ways-to-save-when-you-migrate-sql-server-data-to-azure-sql","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/07\/28\/more-ways-to-save-when-you-migrate-sql-server-data-to-azure-sql\/","title":{"rendered":"More ways to save when you migrate SQL Server data to Azure SQL"},"content":{"rendered":"<p>A new normal is emerging globally as businesses restart or rebuild in the face of rapidly changing conditions. To keep up with the pace of change and address new opportunities that arise, businesses are looking to the cloud for ways to optimize their IT and other data-related costs\u2014and redirect the savings to higher priorities.\u00a0 The <a href=\"https:\/\/azure.microsoft.com\/services\/azure-sql\/\">Azure SQL<\/a> family of database services can help you cost-effectively adapt and scale with flexible options that can help you make the most of your data spend.<\/p>\n<p>Whether you\u2019re rehosting your SQL Server workloads onto an Azure Virtual Machine, or modernizing them on evergreen, fully managed Azure SQL Database or Azure SQL Managed Instance, you\u2019re shifting your capex to opex by avoiding the cost and complexity of buying and managing physical servers.\u00a0 On top of that, Azure provides flexible management options that can boost productivity and provide more bandwidth for IT and database administrators alike to focus on more value-added initiatives. Backups, patching, and updates are performed on your behalf, and features like high availability, performance tuning, and more are part of Azure SQL\u2019s managed services.<\/p>\n<p>What more could you do if you could save up to 80 percent or more on your database costs? <a href=\"https:\/\/aka.ms\/Savings_on_AzureSQL\">Read on<\/a> to discover the top eight ways you can optimize your data spend on Azure.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>A new normal is emerging globally as businesses restart or rebuild in the face of rapidly changing conditions. To keep up with the pace of change and address new opportunities that arise, businesses are looking to the cloud for ways to optimize their IT and other data-related costs\u2014and redirect the savings to higher priorities.<\/p>\n","protected":false},"author":5562,"featured_media":32004,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"ep_exclude_from_search":false,"_classifai_error":"","_classifai_text_to_speech_error":"","footnotes":""},"post_tag":[],"product":[5226,2391],"content-type":[2445],"topic":[],"coauthors":[2628],"class_list":["post-31782","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","product-azure","product-azure-sql-database","content-type-thought-leadership","review-flag-new-1593580247-437"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>More ways to save when you migrate SQL Server data to Azure SQL - Microsoft SQL Server Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/07\/28\/more-ways-to-save-when-you-migrate-sql-server-data-to-azure-sql\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"More ways to save when you migrate SQL Server data to Azure SQL - Microsoft SQL Server Blog\" \/>\n<meta property=\"og:description\" content=\"A new normal is emerging globally as businesses restart or rebuild in the face of rapidly changing conditions. To keep up with the pace of change and address new opportunities that arise, businesses are looking to the cloud for ways to optimize their IT and other data-related costs\u2014and redirect the savings to higher priorities.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/07\/28\/more-ways-to-save-when-you-migrate-sql-server-data-to-azure-sql\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft SQL Server Blog\" \/>\n<meta property=\"article:publisher\" content=\"http:\/\/www.facebook.com\/sqlserver\" \/>\n<meta property=\"article:published_time\" content=\"2020-07-28T17:00:52+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-01-09T06:22:37+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2020\/07\/Win19a_Consumer_TT_0002-1024x683.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1024\" \/>\n\t<meta property=\"og:image:height\" content=\"683\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"John &#039;JG&#039; Chirapurath\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SQLServer\" \/>\n<meta name=\"twitter:site\" content=\"@SQLServer\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"John &#039;JG&#039; Chirapurath\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 min read\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/07\/28\/more-ways-to-save-when-you-migrate-sql-server-data-to-azure-sql\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/07\/28\/more-ways-to-save-when-you-migrate-sql-server-data-to-azure-sql\/\"},\"author\":[{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/john-jg-chirapurath\/\",\"@type\":\"Person\",\"@name\":\"John 'JG' Chirapurath\"}],\"headline\":\"More ways to save when you migrate SQL Server data to Azure SQL\",\"datePublished\":\"2020-07-28T17:00:52+00:00\",\"dateModified\":\"2024-01-09T06:22:37+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/07\/28\/more-ways-to-save-when-you-migrate-sql-server-data-to-azure-sql\/\"},\"wordCount\":232,\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/07\/28\/more-ways-to-save-when-you-migrate-sql-server-data-to-azure-sql\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2020\/07\/Win19a_Consumer_TT_0002-scaled.jpg\",\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/07\/28\/more-ways-to-save-when-you-migrate-sql-server-data-to-azure-sql\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/07\/28\/more-ways-to-save-when-you-migrate-sql-server-data-to-azure-sql\/\",\"name\":\"More ways to save when you migrate SQL Server data to Azure SQL - Microsoft SQL Server Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/07\/28\/more-ways-to-save-when-you-migrate-sql-server-data-to-azure-sql\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/07\/28\/more-ways-to-save-when-you-migrate-sql-server-data-to-azure-sql\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2020\/07\/Win19a_Consumer_TT_0002-scaled.jpg\",\"datePublished\":\"2020-07-28T17:00:52+00:00\",\"dateModified\":\"2024-01-09T06:22:37+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/07\/28\/more-ways-to-save-when-you-migrate-sql-server-data-to-azure-sql\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/07\/28\/more-ways-to-save-when-you-migrate-sql-server-data-to-azure-sql\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/07\/28\/more-ways-to-save-when-you-migrate-sql-server-data-to-azure-sql\/#primaryimage\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2020\/07\/Win19a_Consumer_TT_0002-scaled.jpg\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2020\/07\/Win19a_Consumer_TT_0002-scaled.jpg\",\"width\":2560,\"height\":1707,\"caption\":\"a person sitting in front of a computer\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/07\/28\/more-ways-to-save-when-you-migrate-sql-server-data-to-azure-sql\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"More ways to save when you migrate SQL Server data to Azure SQL\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\",\"name\":\"Microsoft SQL Server Blog\",\"description\":\"Official News from Microsoft\u2019s Information Platform\",\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\",\"name\":\"Microsoft SQL Server Blog\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png\",\"width\":259,\"height\":194,\"caption\":\"Microsoft SQL Server Blog\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"http:\/\/www.facebook.com\/sqlserver\",\"https:\/\/x.com\/SQLServer\",\"https:\/\/www.youtube.com\/user\/MSCloudOS\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"More ways to save when you migrate SQL Server data to Azure SQL - Microsoft SQL Server Blog","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:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/07\/28\/more-ways-to-save-when-you-migrate-sql-server-data-to-azure-sql\/","og_locale":"en_US","og_type":"article","og_title":"More ways to save when you migrate SQL Server data to Azure SQL - Microsoft SQL Server Blog","og_description":"A new normal is emerging globally as businesses restart or rebuild in the face of rapidly changing conditions. To keep up with the pace of change and address new opportunities that arise, businesses are looking to the cloud for ways to optimize their IT and other data-related costs\u2014and redirect the savings to higher priorities.","og_url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/07\/28\/more-ways-to-save-when-you-migrate-sql-server-data-to-azure-sql\/","og_site_name":"Microsoft SQL Server Blog","article_publisher":"http:\/\/www.facebook.com\/sqlserver","article_published_time":"2020-07-28T17:00:52+00:00","article_modified_time":"2024-01-09T06:22:37+00:00","og_image":[{"width":1024,"height":683,"url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2020\/07\/Win19a_Consumer_TT_0002-1024x683.jpg","type":"image\/jpeg"}],"author":"John 'JG' Chirapurath","twitter_card":"summary_large_image","twitter_creator":"@SQLServer","twitter_site":"@SQLServer","twitter_misc":{"Written by":"John 'JG' Chirapurath","Est. reading time":"1 min read"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/07\/28\/more-ways-to-save-when-you-migrate-sql-server-data-to-azure-sql\/#article","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/07\/28\/more-ways-to-save-when-you-migrate-sql-server-data-to-azure-sql\/"},"author":[{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/john-jg-chirapurath\/","@type":"Person","@name":"John 'JG' Chirapurath"}],"headline":"More ways to save when you migrate SQL Server data to Azure SQL","datePublished":"2020-07-28T17:00:52+00:00","dateModified":"2024-01-09T06:22:37+00:00","mainEntityOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/07\/28\/more-ways-to-save-when-you-migrate-sql-server-data-to-azure-sql\/"},"wordCount":232,"publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/07\/28\/more-ways-to-save-when-you-migrate-sql-server-data-to-azure-sql\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2020\/07\/Win19a_Consumer_TT_0002-scaled.jpg","inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/07\/28\/more-ways-to-save-when-you-migrate-sql-server-data-to-azure-sql\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/07\/28\/more-ways-to-save-when-you-migrate-sql-server-data-to-azure-sql\/","name":"More ways to save when you migrate SQL Server data to Azure SQL - Microsoft SQL Server Blog","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/07\/28\/more-ways-to-save-when-you-migrate-sql-server-data-to-azure-sql\/#primaryimage"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/07\/28\/more-ways-to-save-when-you-migrate-sql-server-data-to-azure-sql\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2020\/07\/Win19a_Consumer_TT_0002-scaled.jpg","datePublished":"2020-07-28T17:00:52+00:00","dateModified":"2024-01-09T06:22:37+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/07\/28\/more-ways-to-save-when-you-migrate-sql-server-data-to-azure-sql\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/07\/28\/more-ways-to-save-when-you-migrate-sql-server-data-to-azure-sql\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/07\/28\/more-ways-to-save-when-you-migrate-sql-server-data-to-azure-sql\/#primaryimage","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2020\/07\/Win19a_Consumer_TT_0002-scaled.jpg","contentUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2020\/07\/Win19a_Consumer_TT_0002-scaled.jpg","width":2560,"height":1707,"caption":"a person sitting in front of a computer"},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/07\/28\/more-ways-to-save-when-you-migrate-sql-server-data-to-azure-sql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/"},{"@type":"ListItem","position":2,"name":"More ways to save when you migrate SQL Server data to Azure SQL"}]},{"@type":"WebSite","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/","name":"Microsoft SQL Server Blog","description":"Official News from Microsoft\u2019s Information Platform","publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization","name":"Microsoft SQL Server Blog","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png","contentUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png","width":259,"height":194,"caption":"Microsoft SQL Server Blog"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/"},"sameAs":["http:\/\/www.facebook.com\/sqlserver","https:\/\/x.com\/SQLServer","https:\/\/www.youtube.com\/user\/MSCloudOS"]}]}},"msxcm_display_generated_audio":false,"msxcm_animated_featured_image":null,"_links":{"self":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/31782","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/users\/5562"}],"replies":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/comments?post=31782"}],"version-history":[{"count":0,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/31782\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/media\/32004"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/media?parent=31782"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/post_tag?post=31782"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/product?post=31782"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/content-type?post=31782"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/topic?post=31782"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/coauthors?post=31782"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}