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
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.