{"id":7230,"date":"2010-05-19T00:00:00","date_gmt":"2010-05-19T00:00:00","guid":{"rendered":"https:\/\/azure.microsoft.com\/blog\/exporting-data-from-sql-azure-importexport-wizard"},"modified":"2025-09-11T09:46:13","modified_gmt":"2025-09-11T16:46:13","slug":"exporting-data-from-sql-azure-importexport-wizard","status":"publish","type":"post","link":"https:\/\/azure.microsoft.com\/en-us\/blog\/exporting-data-from-sql-azure-importexport-wizard\/","title":{"rendered":"Exporting Data from SQL Azure: Import\/Export Wizard"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">[This article was contributed by the SQL Azure team.]<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">In this blog post we will show you how to export data from your SQL Azure database to a local SQL Server database using the SQL Server Import and Export Wizard in SQL Server Management Studio 2008 R2. This is a great technique to backup your data on SQL Azure to your local SQL Server.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">We have installed the Adventure Works database for SQL Azure to test with on our SQL Azure account; you can find that database <a href=\"https:\/\/msftdbprodsamples.codeplex.com\/releases\/view\/37304\">here<\/a>.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The first thing we need to do is connect SQL Server Management Studio 2008 R2 to SQL Azure; in this demonstration we are running the SQL Server Import and Export from the SQL Server Management Studio. How to connect to SQL Azure was covered in this blog post.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Here is how to import from SQL Azure:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">1. In SQL Server Management Studio, connect to your local SQL Server (this could be SQL Server Express Edition 2008 R2).<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">2. Create a new database named: <b>AdventureWorksDWAZ2008R2.<\/b><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">3. Right click on that database and choose from the drop down context menu <b>All Tasks<\/b> | <b>Import Data<\/b>\u2026<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2010\/05\/3718.image_5F00_thumb_5F00_5E94752D.webp\" alt=\"screenshot of the AdventureWorksDWA database, then clicking in to &quot;Tasks&quot; and then clicking &quot;import data&quot;\" title=\"image\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">4. This will open the <b>SQL Server Import and Export Wizard <\/b>dialog.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">5. Click next to get past the starting page.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">6. On the next page of the wizard you choose a data source. In this example, this is SQL Azure. The data source you need to connect to SQL Azure is the <b>.NET Framework Data Provider for SqlServer<\/b>.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">7. Scroll to the bottom of the properties, here is where you need to enter your SQL Azure information.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2010\/05\/4174.image_5F00_thumb_5F00_7A095163.webp\" alt=\"screenshot of the SQL Server Import and Export Wizard, with the &quot;Data Source&quot; line item highlighted\" title=\"image\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">8. Under <b>Security<\/b> set <b>Encrypt<\/b> to True.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">9. For the <b>Password<\/b> enter your SQL Azure password.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">10. For <b>User ID<\/b> enter your SQL Azure Administrative username.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">11. Under <b>Source<\/b> for <b>Data Source<\/b> enter the full domain name (Server Name) for your account on SQL Azure. You can get this from the <a href=\"https:\/\/sql.azure.com\/\">SQL Azure Portal<\/a>.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">12. For <b>Initial Catalog<\/b> enter the database name on SQL Azure.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">13. Once you have all the data source information filled out, you can click on <b>Next &gt;<\/b> and the <b>Choose a Destination<\/b> wizard step will appear.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2010\/05\/0081.image_5F00_thumb_5F00_31FB1F7A.webp\" alt=\"screenshot of the SQL Server Import and Export Wizard window and in the &quot;Choose a Destination&quot; task. Destination is set to SQL Server Native Client 10.0 and Database is AdventureWorksDWA database\" title=\"image\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">14. The destination server is your local server in this example. Because we chose <b>Import Data\u2026<\/b> our local database is already filled in for us. Enter your security credentials and click <b>Next &gt;<\/b>. The <b>Specify Table Copy or Query<\/b> dialog will appear.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2010\/05\/7444.image_5F00_thumb_5F00_582D5305.webp\" alt=\"screenshot of the SQL Server Import and Export Wizard window and in the &quot;Specify Table Copy or Query&quot; task. &quot;Copy data from one or more tables or views&quot; radio button is selected\" title=\"image\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">15. Chose <b>Copy data from one or more tables or views <\/b>radio button. Then press <b>Next &gt;<\/b>.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">16. The <b>Select Source Tables and Views<\/b> dialog will appear and the SQL Server Import and Export Wizard will query the SQL Azure database and return a list of tables and views on SQL Azure. Check the ones that you want to import into your local database.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2010\/05\/5315.image_5F00_thumb_5F00_680C71FC.webp\" alt=\"screenshot of the SQL Server Import and Export Wizard window and in the &quot;Select source Tables and Views&quot; task. The first line in the list of sources is &quot;dbo&quot;. &quot;DatabaseLog&quot; and this line item is highlighted\" title=\"image\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">17. Once you have selected the tables and view press Next &gt; and the <b>Save and Run Package<\/b> wizard step will appear.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2010\/05\/8156.image_5F00_thumb_5F00_1CE9516D.webp\" alt=\"screenshot of the SQL Server Import and Export Wizard window and in the &quot;Save and Run Package&quot; task. &quot;Run Immediately&quot; radio button is highlighted\" title=\"image\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">18. Click the <b>Finish &gt;&gt;|<\/b>button and then <b>Finish <\/b>again and the SQL Server Import and Export Wizard will import your data from SQL Azure to your local SQL Server.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2010\/05\/3652.image_5F00_thumb_5F00_3F113726.webp\" alt=\"screenshot of the SQL Server Import and Export Wizard window and in the &quot;The execution was successful&quot; window. Window shows green check mark with &quot;Success&quot; and other detailed information displayed\" title=\"image\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"summary\">Summary<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">SQL Import and Export Wizard is an easy way to backup your data locally from SQL Azure, or you can use it in reverse to export data to SQL Azure. The trickiest part is translating the nomenclature of the .NET Framework Data Provider for SqlServer to the terminology in SQL Azure. Do you have questions, concerns, comments? Post them below and we will try to a<\/p>\n","protected":false},"excerpt":{"rendered":"<p>[This article was contributed by the SQL Azure team.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"ms_queue_id":[],"ep_exclude_from_search":false,"_classifai_error":"","_classifai_text_to_speech_error":"","_alt_title":"","footnotes":"","msx_community_cta_settings":[]},"categories":[1473],"tags":[],"audience":[],"content-type":[1511],"product":[],"tech-community":[],"topic":[],"coauthors":[97],"class_list":["post-7230","post","type-post","status-publish","format-standard","hentry","category-databases","content-type-best-practices","review-flag-1-1680286581-825","review-flag-2-1680286581-601","review-flag-3-1680286581-173","review-flag-4-1680286581-250","review-flag-5-1680286581-950","review-flag-6-1680286581-909","review-flag-7-1680286581-146","review-flag-8-1680286581-263","review-flag-9-1680286581-259","review-flag-new-1680286579-546"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Exporting Data from SQL Azure: Import\/Export Wizard | Microsoft Azure Blog<\/title>\n<meta name=\"description\" content=\"In this blog post we will show you how to export data from your SQL Azure database to a local SQL Server database using the SQL Server Import and\u2026\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/azure.microsoft.com\/en-us\/blog\/exporting-data-from-sql-azure-importexport-wizard\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Exporting Data from SQL Azure: Import\/Export Wizard | Microsoft Azure Blog\" \/>\n<meta property=\"og:description\" content=\"In this blog post we will show you how to export data from your SQL Azure database to a local SQL Server database using the SQL Server Import and\u2026\" \/>\n<meta property=\"og:url\" content=\"https:\/\/azure.microsoft.com\/en-us\/blog\/exporting-data-from-sql-azure-importexport-wizard\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft Azure Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/microsoftazure\" \/>\n<meta property=\"article:published_time\" content=\"2010-05-19T00:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-09-11T16:46:13+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2010\/05\/3718.image_5F00_thumb_5F00_5E94752D.webp\" \/>\n<meta name=\"author\" content=\"Microsoft Azure\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@azure\" \/>\n<meta name=\"twitter:site\" content=\"@azure\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Microsoft Azure\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/exporting-data-from-sql-azure-importexport-wizard\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/exporting-data-from-sql-azure-importexport-wizard\/\"},\"author\":[{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/author\/microsoft-azure\/\",\"@type\":\"Person\",\"@name\":\"Microsoft Azure\"}],\"headline\":\"Exporting Data from SQL Azure: Import\/Export Wizard\",\"datePublished\":\"2010-05-19T00:00:00+00:00\",\"dateModified\":\"2025-09-11T16:46:13+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/exporting-data-from-sql-azure-importexport-wizard\/\"},\"wordCount\":573,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/exporting-data-from-sql-azure-importexport-wizard\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2010\/05\/3718.image_5F00_thumb_5F00_5E94752D.webp\",\"articleSection\":[\"Databases\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/azure.microsoft.com\/en-us\/blog\/exporting-data-from-sql-azure-importexport-wizard\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/exporting-data-from-sql-azure-importexport-wizard\/\",\"url\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/exporting-data-from-sql-azure-importexport-wizard\/\",\"name\":\"Exporting Data from SQL Azure: Import\/Export Wizard | Microsoft Azure Blog\",\"isPartOf\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/exporting-data-from-sql-azure-importexport-wizard\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/exporting-data-from-sql-azure-importexport-wizard\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2010\/05\/3718.image_5F00_thumb_5F00_5E94752D.webp\",\"datePublished\":\"2010-05-19T00:00:00+00:00\",\"dateModified\":\"2025-09-11T16:46:13+00:00\",\"description\":\"In this blog post we will show you how to export data from your SQL Azure database to a local SQL Server database using the SQL Server Import and\u2026\",\"breadcrumb\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/exporting-data-from-sql-azure-importexport-wizard\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/azure.microsoft.com\/en-us\/blog\/exporting-data-from-sql-azure-importexport-wizard\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/exporting-data-from-sql-azure-importexport-wizard\/#primaryimage\",\"url\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2010\/05\/3718.image_5F00_thumb_5F00_5E94752D.webp\",\"contentUrl\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2010\/05\/3718.image_5F00_thumb_5F00_5E94752D.webp\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/exporting-data-from-sql-azure-importexport-wizard\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Blog home\",\"item\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Databases\",\"item\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/category\/databases\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Exporting Data from SQL Azure: Import\/Export Wizard\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#website\",\"url\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/\",\"name\":\"Microsoft Azure Blog\",\"description\":\"Get the latest Azure news, updates, and announcements from the Azure blog. From product updates to hot topics, hear from the Azure experts.\",\"publisher\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#organization\",\"name\":\"Microsoft Azure Blog\",\"url\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2024\/06\/microsoft_logo.webp\",\"contentUrl\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2024\/06\/microsoft_logo.webp\",\"width\":512,\"height\":512,\"caption\":\"Microsoft Azure Blog\"},\"image\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/microsoftazure\",\"https:\/\/x.com\/azure\",\"https:\/\/www.instagram.com\/microsoftdeveloper\/\",\"https:\/\/www.linkedin.com\/company\/16188386\",\"https:\/\/www.youtube.com\/user\/windowsazure\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#\/schema\/person\/c702e5edd662b328b49b7e1180cab117\",\"name\":\"shakir\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/9342c7c05bb16548741bc5cd3a3e3b7ee0c8e746844ad2cc582db5beb5514c6f?s=96&d=mm&r=g7664e653ea371ce16eaf75e9fa8952c4\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/9342c7c05bb16548741bc5cd3a3e3b7ee0c8e746844ad2cc582db5beb5514c6f?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/9342c7c05bb16548741bc5cd3a3e3b7ee0c8e746844ad2cc582db5beb5514c6f?s=96&d=mm&r=g\",\"caption\":\"shakir\"},\"sameAs\":[\"https:\/\/azure.microsoft.com\"],\"url\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/author\/shakir\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Exporting Data from SQL Azure: Import\/Export Wizard | Microsoft Azure Blog","description":"In this blog post we will show you how to export data from your SQL Azure database to a local SQL Server database using the SQL Server Import and\u2026","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:\/\/azure.microsoft.com\/en-us\/blog\/exporting-data-from-sql-azure-importexport-wizard\/","og_locale":"en_US","og_type":"article","og_title":"Exporting Data from SQL Azure: Import\/Export Wizard | Microsoft Azure Blog","og_description":"In this blog post we will show you how to export data from your SQL Azure database to a local SQL Server database using the SQL Server Import and\u2026","og_url":"https:\/\/azure.microsoft.com\/en-us\/blog\/exporting-data-from-sql-azure-importexport-wizard\/","og_site_name":"Microsoft Azure Blog","article_publisher":"https:\/\/www.facebook.com\/microsoftazure","article_published_time":"2010-05-19T00:00:00+00:00","article_modified_time":"2025-09-11T16:46:13+00:00","og_image":[{"url":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2010\/05\/3718.image_5F00_thumb_5F00_5E94752D.webp","type":"","width":"","height":""}],"author":"Microsoft Azure","twitter_card":"summary_large_image","twitter_creator":"@azure","twitter_site":"@azure","twitter_misc":{"Written by":"Microsoft Azure","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/exporting-data-from-sql-azure-importexport-wizard\/#article","isPartOf":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/exporting-data-from-sql-azure-importexport-wizard\/"},"author":[{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/author\/microsoft-azure\/","@type":"Person","@name":"Microsoft Azure"}],"headline":"Exporting Data from SQL Azure: Import\/Export Wizard","datePublished":"2010-05-19T00:00:00+00:00","dateModified":"2025-09-11T16:46:13+00:00","mainEntityOfPage":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/exporting-data-from-sql-azure-importexport-wizard\/"},"wordCount":573,"commentCount":0,"publisher":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#organization"},"image":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/exporting-data-from-sql-azure-importexport-wizard\/#primaryimage"},"thumbnailUrl":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2010\/05\/3718.image_5F00_thumb_5F00_5E94752D.webp","articleSection":["Databases"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/azure.microsoft.com\/en-us\/blog\/exporting-data-from-sql-azure-importexport-wizard\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/exporting-data-from-sql-azure-importexport-wizard\/","url":"https:\/\/azure.microsoft.com\/en-us\/blog\/exporting-data-from-sql-azure-importexport-wizard\/","name":"Exporting Data from SQL Azure: Import\/Export Wizard | Microsoft Azure Blog","isPartOf":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/exporting-data-from-sql-azure-importexport-wizard\/#primaryimage"},"image":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/exporting-data-from-sql-azure-importexport-wizard\/#primaryimage"},"thumbnailUrl":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2010\/05\/3718.image_5F00_thumb_5F00_5E94752D.webp","datePublished":"2010-05-19T00:00:00+00:00","dateModified":"2025-09-11T16:46:13+00:00","description":"In this blog post we will show you how to export data from your SQL Azure database to a local SQL Server database using the SQL Server Import and\u2026","breadcrumb":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/exporting-data-from-sql-azure-importexport-wizard\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/azure.microsoft.com\/en-us\/blog\/exporting-data-from-sql-azure-importexport-wizard\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/exporting-data-from-sql-azure-importexport-wizard\/#primaryimage","url":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2010\/05\/3718.image_5F00_thumb_5F00_5E94752D.webp","contentUrl":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2010\/05\/3718.image_5F00_thumb_5F00_5E94752D.webp"},{"@type":"BreadcrumbList","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/exporting-data-from-sql-azure-importexport-wizard\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog home","item":"https:\/\/azure.microsoft.com\/en-us\/blog\/"},{"@type":"ListItem","position":2,"name":"Databases","item":"https:\/\/azure.microsoft.com\/en-us\/blog\/category\/databases\/"},{"@type":"ListItem","position":3,"name":"Exporting Data from SQL Azure: Import\/Export Wizard"}]},{"@type":"WebSite","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#website","url":"https:\/\/azure.microsoft.com\/en-us\/blog\/","name":"Microsoft Azure Blog","description":"Get the latest Azure news, updates, and announcements from the Azure blog. From product updates to hot topics, hear from the Azure experts.","publisher":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/azure.microsoft.com\/en-us\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#organization","name":"Microsoft Azure Blog","url":"https:\/\/azure.microsoft.com\/en-us\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2024\/06\/microsoft_logo.webp","contentUrl":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2024\/06\/microsoft_logo.webp","width":512,"height":512,"caption":"Microsoft Azure Blog"},"image":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/microsoftazure","https:\/\/x.com\/azure","https:\/\/www.instagram.com\/microsoftdeveloper\/","https:\/\/www.linkedin.com\/company\/16188386","https:\/\/www.youtube.com\/user\/windowsazure"]},{"@type":"Person","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#\/schema\/person\/c702e5edd662b328b49b7e1180cab117","name":"shakir","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/9342c7c05bb16548741bc5cd3a3e3b7ee0c8e746844ad2cc582db5beb5514c6f?s=96&d=mm&r=g7664e653ea371ce16eaf75e9fa8952c4","url":"https:\/\/secure.gravatar.com\/avatar\/9342c7c05bb16548741bc5cd3a3e3b7ee0c8e746844ad2cc582db5beb5514c6f?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/9342c7c05bb16548741bc5cd3a3e3b7ee0c8e746844ad2cc582db5beb5514c6f?s=96&d=mm&r=g","caption":"shakir"},"sameAs":["https:\/\/azure.microsoft.com"],"url":"https:\/\/azure.microsoft.com\/en-us\/blog\/author\/shakir\/"}]}},"msxcm_display_generated_audio":false,"msxcm_animated_featured_image":null,"distributor_meta":false,"distributor_terms":false,"distributor_media":false,"distributor_original_site_name":"Microsoft Azure Blog","distributor_original_site_url":"https:\/\/azure.microsoft.com\/en-us\/blog","push-errors":false,"_links":{"self":[{"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/posts\/7230","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/comments?post=7230"}],"version-history":[{"count":2,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/posts\/7230\/revisions"}],"predecessor-version":[{"id":46091,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/posts\/7230\/revisions\/46091"}],"wp:attachment":[{"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/media?parent=7230"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/categories?post=7230"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/tags?post=7230"},{"taxonomy":"audience","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/audience?post=7230"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/content-type?post=7230"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/product?post=7230"},{"taxonomy":"tech-community","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/tech-community?post=7230"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/topic?post=7230"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/coauthors?post=7230"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}