SQL Server copy table from one database to another

Hello everyone, I am going to share the T-SQL query for copy table from one database to another database using SQL Server 2012. The query detail as given below.

Table of Content

Syntax for copy table from one database to another.
Query for copy table from one database to another.

Syntax

/* COPY TABLE DATA FROM ONE DATABASE TO ANOTHER DATABASE IN SQL SERVER 2012 */

SELECT * INTO DB1.dbo.[Employee] FROM DB2.dbo.[User]

Query for copy table from one database to another

/* COPY TABLE DATA FROM ONE DATABASE TO ANOTHER DATABASE */

SELECT * INTO OBPC.[dbo].[User]

FROM MASTER.[dbo].[User]

You can use the Wizard method to generate SQLServer scripts and for Wizard you can follow below links.

http://blog.sqlauthority.com/2009/07/29/sql-server-2008-copy-database-with-data-generate-t-sql-for-inserting-data-from-one-table-to-another-table/

http://www.c-sharpcorner.com/UploadFile/rohatash/copy-table-with-data-from-one-database-to-another-in-sql-ser/

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/f5ee85c7-c9d3-438e-a835-daa2c785026b/copy-sql-database-tables-to-another-sql-server?forum=sqlgetstarted

Pin it

Anil Singh is an author, tech blogger, and software programmer. Book writing, tech blogging is something do extra and Anil love doing it. For more detail, kindly refer to this link..

My Tech Blog - https://www.code-sample.com/
My Books - Book 1 and Book 2

SQL Server copy table from one database to another

Reviewed by Anil Singh on 6:00 AM Rating: (5)