Copying tables from one database to another is pretty straight foward. No need to create the destination table as the script will create it on the fly.
Assume a database called sourceDB and a database called destinationDB (all owned by dbo for this example). To duplicate the table called myTable the syntax would be.
USE destinationDB
SELECT * INTO destinationTable FROM sourceDB.dbo.myTable
That’s it .. a copy now exists in the destinationDB. One thing you will need to you is establish the primary key on the copy as it is not created as part of the copy.
Advertisement
