{"id":16883,"date":"2021-08-06T17:37:04","date_gmt":"2021-08-06T12:07:04","guid":{"rendered":"http:\/\/onlineappsdba.com\/?p=16883"},"modified":"2021-08-06T17:37:04","modified_gmt":"2021-08-06T12:07:04","slug":"use-external-table-on-azure-sql-managed-instance-to-read-data-from-azure-sql-database","status":"publish","type":"post","link":"https:\/\/onlineappsdba.com\/index.php\/2021\/08\/06\/use-external-table-on-azure-sql-managed-instance-to-read-data-from-azure-sql-database\/","title":{"rendered":"Use external table on Azure SQL Managed Instance to read data from Azure SQL Database."},"content":{"rendered":"<p>In this blog, we are going to cover how to use Use external table on Azure SQL Managed Instance to read data from Azure SQL Database. You can create external tables that access the data on an Azure storage account that allow access to users with azure active directory. generally, it is the same way to create the external table like you create an external table in SQL Server.<\/p>\n<p>The External table is created on manage instance, Using create EXTERNAL DATA SOURCE(Transact-SQL). This is the way to consume the data from Azure SQL Database on Managed Instance. This sort of arrangement could be helpful to applications that need to devour both Managed Instance and SQL Database information, or maybe for an online relocation of information from SQL Database to Managed Instance. This article discloses how to set this up.<\/p>\n<p>Want to know more about Use external table on Azure SQL Managed Instance to read data from Azure SQL Database. ?<\/p>\n<p>Read the blog post at <a href=\"https:\/\/k21academy.com\/microsoft-azure\/database-administrator\/optimize-query-performance-in-sql-server\/?utm_source=onlineappsdba&amp;utm_medium=referral&amp;utm_campaign=dp30015_august21\" target=\"_blank\" rel=\"noopener noreferrer\"><em><strong>https:\/\/k21academy.com\/dp30015<\/strong><\/em><\/a> to learn more.<\/p>\n<p>Topics, we\u2019ll cover:<\/p>\n<p>1. Networking Requirements<\/p>\n<p>2. Create authentication credentials on managed instance<\/p>\n<p>3. Create an external table on managed instance<\/p>\n<p>4. Create external data source on managed instance<\/p>\n<p>5. Test querying data from SQL Database on Managed Instance<\/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<p>Also, do not forget to join us on our FREE Telegram group <a href=\"https:\/\/t.me\/k21microsoftazure\"><em><strong>https:\/\/t.me\/k21microsoftazure<\/strong><\/em><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>In this blog, we are going to cover how to use Use external table on Azure SQL Managed Instance to [&hellip;]<\/p>\n","protected":false},"author":115,"featured_media":16884,"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-16883","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>Use External Table On SQL Managed Instance To Read Data From SQL<\/title>\n<meta name=\"description\" content=\"This article explains how to use and create external table on Azure SQL Managed Instance to read data from Azure SQL Database.\" \/>\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\/06\/use-external-table-on-azure-sql-managed-instance-to-read-data-from-azure-sql-database\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Use External Table On SQL Managed Instance To Read Data From SQL\" \/>\n<meta property=\"og:description\" content=\"This article explains how to use and create external table on Azure SQL Managed Instance to read data from Azure SQL Database.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/onlineappsdba.com\/index.php\/2021\/08\/06\/use-external-table-on-azure-sql-managed-instance-to-read-data-from-azure-sql-database\/\" \/>\n<meta property=\"article:published_time\" content=\"2021-08-06T12:07:04+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/onlineappsdba.com\/wp-content\/uploads\/2021\/08\/SQL2_BlogImage1.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\/06\/use-external-table-on-azure-sql-managed-instance-to-read-data-from-azure-sql-database\/\",\"url\":\"https:\/\/onlineappsdba.com\/index.php\/2021\/08\/06\/use-external-table-on-azure-sql-managed-instance-to-read-data-from-azure-sql-database\/\",\"name\":\"Use External Table On SQL Managed Instance To Read Data From SQL\",\"isPartOf\":{\"@id\":\"https:\/\/onlineappsdba.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2021\/08\/06\/use-external-table-on-azure-sql-managed-instance-to-read-data-from-azure-sql-database\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2021\/08\/06\/use-external-table-on-azure-sql-managed-instance-to-read-data-from-azure-sql-database\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/onlineappsdba.com\/wp-content\/uploads\/2021\/08\/SQL2_BlogImage1.png\",\"datePublished\":\"2021-08-06T12:07:04+00:00\",\"author\":{\"@id\":\"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb\"},\"description\":\"This article explains how to use and create external table on Azure SQL Managed Instance to read data from Azure SQL Database.\",\"breadcrumb\":{\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2021\/08\/06\/use-external-table-on-azure-sql-managed-instance-to-read-data-from-azure-sql-database\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/onlineappsdba.com\/index.php\/2021\/08\/06\/use-external-table-on-azure-sql-managed-instance-to-read-data-from-azure-sql-database\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2021\/08\/06\/use-external-table-on-azure-sql-managed-instance-to-read-data-from-azure-sql-database\/#primaryimage\",\"url\":\"https:\/\/onlineappsdba.com\/wp-content\/uploads\/2021\/08\/SQL2_BlogImage1.png\",\"contentUrl\":\"https:\/\/onlineappsdba.com\/wp-content\/uploads\/2021\/08\/SQL2_BlogImage1.png\",\"width\":1125,\"height\":629},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2021\/08\/06\/use-external-table-on-azure-sql-managed-instance-to-read-data-from-azure-sql-database\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/onlineappsdba.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Use external table on Azure SQL Managed Instance to read data from 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":"Use External Table On SQL Managed Instance To Read Data From SQL","description":"This article explains how to use and create external table on Azure SQL Managed Instance to read data from Azure SQL Database.","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\/06\/use-external-table-on-azure-sql-managed-instance-to-read-data-from-azure-sql-database\/","og_locale":"en_US","og_type":"article","og_title":"Use External Table On SQL Managed Instance To Read Data From SQL","og_description":"This article explains how to use and create external table on Azure SQL Managed Instance to read data from Azure SQL Database.","og_url":"https:\/\/onlineappsdba.com\/index.php\/2021\/08\/06\/use-external-table-on-azure-sql-managed-instance-to-read-data-from-azure-sql-database\/","article_published_time":"2021-08-06T12:07:04+00:00","og_image":[{"width":1125,"height":629,"url":"https:\/\/onlineappsdba.com\/wp-content\/uploads\/2021\/08\/SQL2_BlogImage1.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\/06\/use-external-table-on-azure-sql-managed-instance-to-read-data-from-azure-sql-database\/","url":"https:\/\/onlineappsdba.com\/index.php\/2021\/08\/06\/use-external-table-on-azure-sql-managed-instance-to-read-data-from-azure-sql-database\/","name":"Use External Table On SQL Managed Instance To Read Data From SQL","isPartOf":{"@id":"https:\/\/onlineappsdba.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/onlineappsdba.com\/index.php\/2021\/08\/06\/use-external-table-on-azure-sql-managed-instance-to-read-data-from-azure-sql-database\/#primaryimage"},"image":{"@id":"https:\/\/onlineappsdba.com\/index.php\/2021\/08\/06\/use-external-table-on-azure-sql-managed-instance-to-read-data-from-azure-sql-database\/#primaryimage"},"thumbnailUrl":"https:\/\/onlineappsdba.com\/wp-content\/uploads\/2021\/08\/SQL2_BlogImage1.png","datePublished":"2021-08-06T12:07:04+00:00","author":{"@id":"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb"},"description":"This article explains how to use and create external table on Azure SQL Managed Instance to read data from Azure SQL Database.","breadcrumb":{"@id":"https:\/\/onlineappsdba.com\/index.php\/2021\/08\/06\/use-external-table-on-azure-sql-managed-instance-to-read-data-from-azure-sql-database\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/onlineappsdba.com\/index.php\/2021\/08\/06\/use-external-table-on-azure-sql-managed-instance-to-read-data-from-azure-sql-database\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/onlineappsdba.com\/index.php\/2021\/08\/06\/use-external-table-on-azure-sql-managed-instance-to-read-data-from-azure-sql-database\/#primaryimage","url":"https:\/\/onlineappsdba.com\/wp-content\/uploads\/2021\/08\/SQL2_BlogImage1.png","contentUrl":"https:\/\/onlineappsdba.com\/wp-content\/uploads\/2021\/08\/SQL2_BlogImage1.png","width":1125,"height":629},{"@type":"BreadcrumbList","@id":"https:\/\/onlineappsdba.com\/index.php\/2021\/08\/06\/use-external-table-on-azure-sql-managed-instance-to-read-data-from-azure-sql-database\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/onlineappsdba.com\/"},{"@type":"ListItem","position":2,"name":"Use external table on Azure SQL Managed Instance to read data from 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\/16883","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=16883"}],"version-history":[{"count":0,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/posts\/16883\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/media\/16884"}],"wp:attachment":[{"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/media?parent=16883"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/categories?post=16883"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/tags?post=16883"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}