{"id":15857,"date":"2020-08-08T05:16:03","date_gmt":"2020-08-08T05:16:03","guid":{"rendered":"https:\/\/www.testpreptraining.com\/tutorial\/?page_id=15857"},"modified":"2020-08-08T05:16:04","modified_gmt":"2020-08-08T05:16:04","slug":"azure-sql-managed-instance","status":"publish","type":"page","link":"https:\/\/www.testpreptraining.ai\/tutorial\/azure-sql-managed-instance\/","title":{"rendered":"Azure SQL Managed Instance"},"content":{"rendered":"\n<p>Azure SQL Managed Instance\u00a0creates a database with near 100% compatibility with the latest SQL Server (Enterprise Edition) database engine, providing a native\u00a0virtual network (VNet)\u00a0implementation that addresses common security concerns, and a\u00a0business model\u00a0favorable for existing SQL Server customers.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"configure-environment\"><strong>Configure environment<\/strong><\/h3>\n\n\n\n<p>Firstly, you will need to create your first SQL Managed Instance with the network environment where it will be placed, and enable connection from the computer or virtual machine where you are executing queries to SQL Managed Instance. You can use the following guides:<\/p>\n\n\n\n<p>Create a SQL Managed Instance using the Azure portal. In the Azure portal, you configure the necessary parameters (username\/password, number of cores, and max storage amount), and automatically create the Azure network environment without the need to know about networking details and infrastructure requirements.<\/p>\n\n\n\n<p> For client application access, you can either\u00a0<strong>create a VM in the same VNet (different subnet)<\/strong>\u00a0or\u00a0<strong>create a point-to-site VPN connection to the VNet from your client computer<\/strong>\u00a0using one of these quickstarts:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Firstly, Enable\u00a0public endpoint\u00a0on your SQL Managed Instance in order to access your data directly from your environment.<\/li><li>Secondly, Create\u00a0Azure Virtual Machine in the SQL Managed Instance VNet\u00a0for client application connectivity, including SQL Server Management Studio.<\/li><li>Lastly, Set up\u00a0point-to-site VPN connection to your SQL Managed Instance\u00a0from your client computer on which you have SQL Server Management Studio and other client connectivity applications. This is other of two options for connectivity to your SQL Managed Instance and to its VNet.<\/li><\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"migrate-your-databases\"><strong>Migrate your databases<\/strong><\/h3>\n\n\n\n<p>After you create a SQL Managed Instance and configure access, you can start migrating your SQL Server databases. Migration can fail if you have some unsupported features in the source database that you want to migrate. To avoid failures and check compatibility, you can use\u00a0Data Migration Assistant (DMA)\u00a0to analyze your databases on SQL Server and find any issue that could block migration to a SQL Managed Instance, such as existence of\u00a0FileStream\u00a0or multiple log files.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"customize-network-environment\"><strong>Customize network environment<\/strong><\/h3>\n\n\n\n<p>Although the VNet\/subnet can be automatically configured when the instance is\u00a0created using the Azure portal, it might be good to create it before you start creating instances in SQL Managed Instance. This is because you can configure the parameters of VNet and subnet. The easiest way to create and configure the network environment is to use the\u00a0Azure Resource deployment\u00a0template that creates and configures your network and subnet where it will be placed. You just need to press the Azure Resource Manager deploy button and populate the form with parameters.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"migrate-to-a-sql-managed-instance\"><strong>Migrate to a SQL Managed Instance<\/strong><\/h3>\n\n\n\n<p>\u00a0in order to migrate your production database or even dev\/test databases that you want to use for some performance test. you would need to consider using some additional techniques, such as:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Firstly, Performance testing\u00a0<\/li><li>Also, Online migration<\/li><\/ul>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><a href=\"https:\/\/www.testpreptraining.ai\/microsoft-azure-architect-technologies-az-303-free-practice-test\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" width=\"960\" height=\"150\" src=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/07\/Untitled-design-5.png\" alt=\"free practice test for AZ- 303\" class=\"wp-image-13928\" srcset=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/07\/Untitled-design-5.png 960w, https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/07\/Untitled-design-5-750x117.png 750w\" sizes=\"auto, (max-width: 960px) 100vw, 960px\" \/><\/a><\/figure><\/div>\n\n\n\n<p><a href=\"https:\/\/www.testpreptraining.ai\/tutorial\/exam-az-303-microsoft-azure-architect-technologies\/\" target=\"_blank\" rel=\"noreferrer noopener\"><strong>Go back to home page <\/strong><\/a><\/p>\n\n\n\n<p class=\"has-text-align-right\"><strong>Reference documentation &#8211;<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/azure-sql\/managed-instance\/quickstart-content-reference-guide\" target=\"_blank\" rel=\"noreferrer noopener\">Getting started with Azure SQL Managed Instance<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Azure SQL Managed Instance\u00a0creates a database with near 100% compatibility with the latest SQL Server (Enterprise Edition) database engine, providing a native\u00a0virtual network (VNet)\u00a0implementation that addresses common security concerns, and a\u00a0business model\u00a0favorable for existing SQL Server customers. Configure environment Firstly, you will need to create your first SQL Managed Instance with the network environment where&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_acf_changed":false,"footnotes":""},"categories":[],"tags":[],"class_list":["post-15857","page","type-page","status-publish","hentry"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Azure SQL Managed Instance - Testprep Training Tutorials<\/title>\n<meta name=\"description\" content=\"Enhance and upgrade your Azure Architect skills by preparing from tutorial - Azure SQL Managed Instance. Crack the exam now!\" \/>\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.testpreptraining.ai\/tutorial\/azure-sql-managed-instance\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Azure SQL Managed Instance - Testprep Training Tutorials\" \/>\n<meta property=\"og:description\" content=\"Enhance and upgrade your Azure Architect skills by preparing from tutorial - Azure SQL Managed Instance. Crack the exam now!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.testpreptraining.ai\/tutorial\/azure-sql-managed-instance\/\" \/>\n<meta property=\"og:site_name\" content=\"Testprep Training Tutorials\" \/>\n<meta property=\"article:modified_time\" content=\"2020-08-08T05:16:04+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/07\/Untitled-design-5.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/azure-sql-managed-instance\/\",\"url\":\"https:\/\/www.testpreptraining.ai\/tutorial\/azure-sql-managed-instance\/\",\"name\":\"Azure SQL Managed Instance - Testprep Training Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#website\"},\"datePublished\":\"2020-08-08T05:16:03+00:00\",\"dateModified\":\"2020-08-08T05:16:04+00:00\",\"description\":\"Enhance and upgrade your Azure Architect skills by preparing from tutorial - Azure SQL Managed Instance. Crack the exam now!\",\"breadcrumb\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/azure-sql-managed-instance\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.testpreptraining.ai\/tutorial\/azure-sql-managed-instance\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/azure-sql-managed-instance\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.testpreptraining.ai\/tutorial\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Azure SQL Managed Instance\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#website\",\"url\":\"https:\/\/www.testpreptraining.ai\/tutorial\/\",\"name\":\"Testprep Training Tutorials\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.testpreptraining.ai\/tutorial\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#organization\",\"name\":\"Testprep Training\",\"url\":\"https:\/\/www.testpreptraining.ai\/tutorial\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.testpreptraining.com\/tutorial\/wp-content\/uploads\/2020\/07\/tpt-logo-6.png\",\"contentUrl\":\"https:\/\/www.testpreptraining.com\/tutorial\/wp-content\/uploads\/2020\/07\/tpt-logo-6.png\",\"width\":583,\"height\":153,\"caption\":\"Testprep Training\"},\"image\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Azure SQL Managed Instance - Testprep Training Tutorials","description":"Enhance and upgrade your Azure Architect skills by preparing from tutorial - Azure SQL Managed Instance. Crack the exam now!","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.testpreptraining.ai\/tutorial\/azure-sql-managed-instance\/","og_locale":"en_US","og_type":"article","og_title":"Azure SQL Managed Instance - Testprep Training Tutorials","og_description":"Enhance and upgrade your Azure Architect skills by preparing from tutorial - Azure SQL Managed Instance. Crack the exam now!","og_url":"https:\/\/www.testpreptraining.ai\/tutorial\/azure-sql-managed-instance\/","og_site_name":"Testprep Training Tutorials","article_modified_time":"2020-08-08T05:16:04+00:00","og_image":[{"url":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/07\/Untitled-design-5.png"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/azure-sql-managed-instance\/","url":"https:\/\/www.testpreptraining.ai\/tutorial\/azure-sql-managed-instance\/","name":"Azure SQL Managed Instance - Testprep Training Tutorials","isPartOf":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#website"},"datePublished":"2020-08-08T05:16:03+00:00","dateModified":"2020-08-08T05:16:04+00:00","description":"Enhance and upgrade your Azure Architect skills by preparing from tutorial - Azure SQL Managed Instance. Crack the exam now!","breadcrumb":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/azure-sql-managed-instance\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.testpreptraining.ai\/tutorial\/azure-sql-managed-instance\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/azure-sql-managed-instance\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.testpreptraining.ai\/tutorial\/"},{"@type":"ListItem","position":2,"name":"Azure SQL Managed Instance"}]},{"@type":"WebSite","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#website","url":"https:\/\/www.testpreptraining.ai\/tutorial\/","name":"Testprep Training Tutorials","description":"","publisher":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.testpreptraining.ai\/tutorial\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#organization","name":"Testprep Training","url":"https:\/\/www.testpreptraining.ai\/tutorial\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#\/schema\/logo\/image\/","url":"https:\/\/www.testpreptraining.com\/tutorial\/wp-content\/uploads\/2020\/07\/tpt-logo-6.png","contentUrl":"https:\/\/www.testpreptraining.com\/tutorial\/wp-content\/uploads\/2020\/07\/tpt-logo-6.png","width":583,"height":153,"caption":"Testprep Training"},"image":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#\/schema\/logo\/image\/"}}]}},"_links":{"self":[{"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/pages\/15857","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/comments?post=15857"}],"version-history":[{"count":1,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/pages\/15857\/revisions"}],"predecessor-version":[{"id":15858,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/pages\/15857\/revisions\/15858"}],"wp:attachment":[{"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/media?parent=15857"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/categories?post=15857"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/tags?post=15857"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}