{"id":3840,"date":"2016-09-09T03:29:40","date_gmt":"2016-09-09T03:29:40","guid":{"rendered":"http:\/\/www.withdata.com\/blog\/?p=3840"},"modified":"2026-07-25T05:13:33","modified_gmt":"2026-07-25T05:13:33","slug":"batch-copy-data-from-one-sql-server-tables-to-another-sql-server","status":"publish","type":"post","link":"https:\/\/www.withdata.com\/blog\/mssqlcopier\/batch-copy-data-from-one-sql-server-tables-to-another-sql-server.html","title":{"rendered":"Batch copy data from one SQL Server tables to another SQL Server"},"content":{"rendered":"<p>Want to batch copy data from one <a href=\"https:\/\/www.microsoft.com\/en-us\/cloud-platform\/sql-server\">SQL Server<\/a> tables to another SQL Server?<\/p>\n<p>Using <a href=\"https:\/\/www.withdata.com\/mssqlcopier\/\">MsSqlCopier<\/a>, you can batch copy data from one SQL Server tables to another SQL Server 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 one SQL Server tables to another SQL Server<\/h2>\n<p>Click &#8220;Wizard &#8211; Tables To Tables&#8221; at task dialog.<\/p>\n<p><img decoding=\"async\" src=\"http:\/\/www.withdata.com\/images\/dbcopier\/wizard_a_1.png\" alt=\"Batch copy data from one SQL Server tables to another SQL Server - 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=\"http:\/\/www.withdata.com\/images\/dbcopier\/wizard_batch_source_has-schema.png\" alt=\"Batch copy data from one SQL Server tables to another SQL Server - Open Source schema\" width=\"722\" height=\"572\" style=\"max-width:100%;height:auto;display:block;\" \/><\/p>\n<p>2. Open Target.<\/p>\n<p><img decoding=\"async\" src=\"http:\/\/www.withdata.com\/images\/dbcopier\/wizard_batch_target_has-schema.png\" alt=\"Batch convert data from one SQL Server tables to another SQL Server - 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=\"http:\/\/www.withdata.com\/images\/dbcopier\/wizard_batch_map.png\" alt=\"Batch import data from one SQL Server tables to another SQL Server - 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=\"http:\/\/www.withdata.com\/images\/dbcopier\/wizard_batch_convert.png\" alt=\"Batch transfer data from one SQL Server tables to another SQL Server - 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=\"http:\/\/www.withdata.com\/mssqlcopier\/\">More about MsSqlCopier &#8211; the tool to copy SQL Server data to another SQL Server<\/a><\/p>\n<div style=\"clear: both;\">\n<p>30-day free trial <a href=\"http:\/\/www.withdata.com\/down\/MsSqlCopier.exe\"><img decoding=\"async\" src=\"http:\/\/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=\"http:\/\/www.withdata.com\/mssqlcopier\/purchase.html\"><img decoding=\"async\" src=\"http:\/\/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 one SQL Server tables to another SQL Server? Using MsSqlCopier, you can batch copy data from one SQL Server tables to another SQL Server easily and fast, just a few mouse clicks! Here you can download and install MsSqlCopier. Copy data from one SQL Server tables to another SQL [&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":[1476,1321],"class_list":["post-3840","post","type-post","status-publish","format-standard","hentry","category-mssqlcopier","tag-batch-copy-tables","tag-sql-server"],"_links":{"self":[{"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts\/3840","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=3840"}],"version-history":[{"count":7,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts\/3840\/revisions"}],"predecessor-version":[{"id":27052,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts\/3840\/revisions\/27052"}],"wp:attachment":[{"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/media?parent=3840"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/categories?post=3840"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/tags?post=3840"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}