{"id":9305,"date":"2025-08-29T05:32:36","date_gmt":"2025-08-29T05:32:36","guid":{"rendered":"http:\/\/www.withdata.com\/blog\/?p=9305"},"modified":"2026-07-25T05:13:33","modified_gmt":"2026-07-25T05:13:33","slug":"copy-sql-server-tables","status":"publish","type":"post","link":"https:\/\/www.withdata.com\/blog\/mssqlcopier\/copy-sql-server-tables.html","title":{"rendered":"Copy SQL Server tables between databases"},"content":{"rendered":"<p>Want to clone  <a href=\"https:\/\/www.microsoft.com\/en-us\/cloud-platform\/sql-server\">SQL Server<\/a>  tables, or copy data in  <a href=\"https:\/\/www.microsoft.com\/en-us\/cloud-platform\/sql-server\">SQL Server<\/a>  tables from one database to another?<\/p>\n<p>Try Withdata <a href=\"https:\/\/www.withdata.com\/db-copier\/\">DB Copier<\/a>, a desktop SQL Server data transfer for Windows, MacOS, and Linux, Clone SQL Server tables, Copy data in SQL Server tables between databases, East and Fast.<\/p>\n<ul>\n<li>Can run in <span id=\"gui\">GUI<\/span> mode, <a href=\"#copy\">Step by Step<\/a>, just a few mouse clicks.<\/li>\n<li>Can run in <a href=\"\/tools\/db-to-db\/copy-between-mssql-cmd\" target=\"_blank\">Command line<\/a>, for <a href=\"\/tools\/db-to-db\/copy-between-mssql-task\" target=\"_blank\">Scheduled Tasks<\/a> and Streams.<\/li>\n<li>Support <a href=\"\/tools\/db-to-db\/copy-between-mssql-windows\" target=\"_blank\">Windows<\/a>, <a href=\"\/tools\/db-to-db\/copy-between-mssql-linux\" target=\"_blank\">Linux<\/a>, and <a href=\"\/tools\/db-to-db\/copy-between-mssql-macos\" target=\"_blank\">macOS<\/a>.<\/li>\n<\/ul>\n<p><a href=\"#download-top\" onclick=\"dtv.style.display = 'block';\">Download Withdata DBCopier<\/a>  <a href=\"#download-top\" onclick=\"dtv.style.display = 'block';\"><img decoding=\"async\" src=\"https:\/\/www.withdata.com\/images\/download_3.jpg\" alt=\"Download DBCopier\" width=\"80\" height=\"22\" style=\"max-width:100%;height:auto;\" \/><\/a> <span id=\"dtv\" style=\"display: none;\"><br \/>\n<a href=\"\/download.php?app=DBCopier&#038;ver=win64\">Windows 64 bit<\/a><br \/>\n<a href=\"\/download.php?app=DBCopier&#038;ver=win32\">Windows 32 bit<\/a><br \/>\n<a href=\"\/download.php?app=DBCopier&#038;ver=deb\">Linux .deb (For Debian, Ubuntu) 64 bit<\/a><br \/>\n<a href=\"\/download.php?app=DBCopier&#038;ver=rpm\">Linux .rpm (For Red Hat, Fedora, SUSE) 64 bit<\/a><br \/>\n<a href=\"\/download.php?app=DBCopier&#038;ver=pkg\">MacOS 64 bit<\/a><br \/>\n<\/span><\/p>\n<h2 id=\"copy\">Copy SQL Server tables between databases<\/h2>\n<p><a href=\"#login\">Login to source and target SQL Server<\/a> -> <a href=\"#source\">Select SQL Server tables to copy<\/a> -> <a href=\"#do\">Copy data between SQL Server databases<\/a><\/p>\n<p id=\"login\"> Choose source\/target SQL Server database and logon.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/www.withdata.com\/images\/logon\/choose_sql-server_logon.png\" alt=\"copy data between SQL Server  databases - Choose SQL Server and logon\" width=\"430\" height=\"442\" style=\"max-width:100%;height:auto;display:block;\" \/><\/p>\n<p>Click &#8220;Convert All 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 one SQL Server tables to another SQL Server - Task Window\" width=\"636\" height=\"479\" style=\"max-width:100%;height:auto;display:block;\" loading=\"lazy\" decoding=\"async\" \/><\/p>\n<p>then show the wizard.<\/p>\n<h3 id=\"source\">1. Select source SQL Server tables.<\/h3>\n<p><img decoding=\"async\" src=\"https:\/\/www.withdata.com\/images\/dbcopier\/wizard_batch_source_has-schema.png\" alt=\"Batch copy tables data from one SQL Server to another - select tables\" width=\"722\" height=\"572\" style=\"max-width:100%;height:auto;display:block;\" loading=\"lazy\" decoding=\"async\" \/><\/p>\n<h3>2. List target SQL Server tables.<\/h3>\n<p><img decoding=\"async\" src=\"https:\/\/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<h3>3. Select target SQL Server tables to copy data.<\/h3>\n<p><img decoding=\"async\" src=\"https:\/\/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<h3 id=\"do\">4. Copy SQL Server tables between databases.<\/h3>\n<p><img decoding=\"async\" src=\"https:\/\/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>More about <a href=\"\/tools\/db-to-db\/copy-between-mssql\">SQL Server Copier<\/a><\/p>\n<div id=\"download-bottom\" style=\"clear: both;\">\n<p>Download Withdata DBCopier<a href=\"#download-bottom\" onclick=\"dbv.style.display = 'block';\"><img decoding=\"async\" src=\"https:\/\/www.withdata.com\/images\/btn_download_green.png\" alt=\"Download DBCopier\" width=\"165\" height=\"50\" style=\"max-width:100%;height:auto;\" loading=\"lazy\" decoding=\"async\" \/><\/a> <span id=\"dbv\" style=\"display: none;\"><br \/>\n<a href=\"\/download.php?app=DBCopier&#038;ver=win64\">Windows 64 bit<\/a><br \/>\n<a href=\"\/download.php?app=DBCopier&#038;ver=win32\">Windows 32 bit<\/a><br \/>\n<a href=\"\/download.php?app=DBCopier&#038;ver=deb\">Linux .deb (For Debian, Ubuntu) 64 bit<\/a><br \/>\n<a href=\"\/download.php?app=DBCopier&#038;ver=rpm\">Linux .rpm (For Red Hat, Fedora, SUSE) 64 bit<\/a><br \/>\n<a href=\"\/download.php?app=DBCopier&#038;ver=pkg\">MacOS 64 bit<\/a><br \/>\n<\/span><\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Want to clone SQL Server tables, or copy data in SQL Server tables from one database to another? Try Withdata DB Copier, a desktop SQL Server data transfer for Windows, MacOS, and Linux, Clone SQL Server tables, Copy data in SQL Server tables between databases, East and Fast. Can run in GUI mode, Step by [&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":[13305,1321],"class_list":["post-9305","post","type-post","status-publish","format-standard","hentry","category-mssqlcopier","tag-batch-copy","tag-sql-server"],"_links":{"self":[{"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts\/9305","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=9305"}],"version-history":[{"count":14,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts\/9305\/revisions"}],"predecessor-version":[{"id":45119,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts\/9305\/revisions\/45119"}],"wp:attachment":[{"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/media?parent=9305"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/categories?post=9305"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/tags?post=9305"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}