{"id":9303,"date":"2018-03-20T14:29:58","date_gmt":"2018-03-20T14:29:58","guid":{"rendered":"http:\/\/www.withdata.com\/blog\/?p=9303"},"modified":"2026-07-25T05:13:33","modified_gmt":"2026-07-25T05:13:33","slug":"copy-data-from-azure-sql-database-tables-to-local-sql-server-database-without-programming","status":"publish","type":"post","link":"https:\/\/www.withdata.com\/blog\/mssqlcopier\/copy-data-from-azure-sql-database-tables-to-local-sql-server-database-without-programming.html","title":{"rendered":"Copy data from Azure SQL database tables to local SQL Server database without programming"},"content":{"rendered":"<p>Want to batch copy data from <a href=\"https:\/\/azure.microsoft.com\">Azure<\/a> SQL database tables to local SQL Server database?<\/p>\n<p>Using <a href=\"https:\/\/www.withdata.com\/mssqlcopier\/\">MsSqlCopier<\/a>, you can batch copy data from Azure SQL database tables to local SQL Server database easily and fast, just a few mouse clicks!<\/p>\n<p>Here you can <a href=\"https:\/\/www.withdata.com\/down\/MsSqlCopier.exe\">download<\/a> and install <a href=\"https:\/\/www.withdata.com\/mssqlcopier\/\">MsSqlCopier<\/a>.<\/p>\n<h2>Copy data from Azure SQL database tables to local SQL Server database<\/h2>\n<p>First, Login to <a href=\"https:\/\/azure.microsoft.com\">Azure<\/a> SQL database.<\/p>\n<p>You need choice your database in &#8220;Database&#8221; list.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/www.withdata.com\/images\/cloud\/azure_logon.png\" alt=\"Batch copy data from Azure SQL database tables to local SQL Server - login to Azure\" width=\"410\" height=\"330\" style=\"max-width:100%;height:auto;display:block;\" \/><\/p>\n<p>Click &#8220;Wizard &#8211; Tables To Tables&#8221; at task dialog.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/www.withdata.com\/images\/dbcopier\/wizard_a_1.png\" alt=\"Batch copy data from Azure SQL database tables to local SQL Server database - Task Window\" width=\"636\" height=\"479\" style=\"max-width:100%;height:auto;display:block;\" \/><\/p>\n<p>then show the wizard.<\/p>\n<p>1. Open Source.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/www.withdata.com\/images\/dbcopier\/wizard_batch_source_has-schema.png\" alt=\"Batch copy data from Azure SQL database tables to local SQL Server database - Open Source schema\" width=\"722\" height=\"572\" style=\"max-width:100%;height:auto;display:block;\" loading=\"lazy\" decoding=\"async\" \/><\/p>\n<p>2. Open Target.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/www.withdata.com\/images\/dbcopier\/wizard_batch_target_has-schema.png\" alt=\"Batch convert data from Azure SQL database tables to local SQL Server database - select destination schema\" width=\"724\" height=\"573\" style=\"max-width:100%;height:auto;display:block;\" loading=\"lazy\" decoding=\"async\" \/><\/p>\n<p>3. Select tables to copy data.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/www.withdata.com\/images\/dbcopier\/wizard_batch_map.png\" alt=\"Batch import data from Azure SQL database tables to local SQL Server database - select tables\" width=\"722\" height=\"572\" style=\"max-width:100%;height:auto;display:block;\" loading=\"lazy\" decoding=\"async\" \/><\/p>\n<p>4. Copy data.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/www.withdata.com\/images\/dbcopier\/wizard_batch_convert.png\" alt=\"Batch transfer data from Azure SQL database tables to local SQL Server database - import\" width=\"722\" height=\"572\" style=\"max-width:100%;height:auto;display:block;\" loading=\"lazy\" decoding=\"async\" \/><\/p>\n<hr style=\"clear: both;\" \/>\n<p><a href=\"https:\/\/www.withdata.com\/mssqlcopier\/\">More about MsSqlCopier &#8211; the tool to copy Azure SQL database data to local SQL Server database<\/a><\/p>\n<div style=\"clear: both;\">\n<p>30-day free trial <a href=\"https:\/\/www.withdata.com\/down\/MsSqlCopier.exe\"><img decoding=\"async\" src=\"https:\/\/www.withdata.com\/images\/btn_download_green.png\" alt=\"Download MsSqlCopier\" width=\"165\" height=\"50\" style=\"max-width:100%;height:auto;\" loading=\"lazy\" decoding=\"async\" \/><\/a>US$95.0 <a href=\"https:\/\/www.withdata.com\/mssqlcopier\/purchase.html\"><img decoding=\"async\" src=\"https:\/\/www.withdata.com\/images\/btn_buynow_green.png\" alt=\"Buy MsSqlCopier\" width=\"154\" height=\"45\" style=\"max-width:100%;height:auto;\" loading=\"lazy\" decoding=\"async\" \/> <\/a><\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Want to batch copy data from Azure SQL database tables to local SQL Server database? Using MsSqlCopier, you can batch copy data from Azure SQL database tables to local SQL Server database easily and fast, just a few mouse clicks! Here you can download and install MsSqlCopier. Copy data from Azure SQL database tables to [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1460],"tags":[2417,2418,2448],"class_list":["post-9303","post","type-post","status-publish","format-standard","hentry","category-mssqlcopier","tag-azure","tag-azure-sql-database","tag-azure-sql-database-to-sql-server"],"_links":{"self":[{"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts\/9303","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/comments?post=9303"}],"version-history":[{"count":2,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts\/9303\/revisions"}],"predecessor-version":[{"id":27053,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts\/9303\/revisions\/27053"}],"wp:attachment":[{"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/media?parent=9303"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/categories?post=9303"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/tags?post=9303"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}