Move a table from one database to another database SQL Server

If the databases are on same server then do it like this,

select * into DB_2.T1 from DB_1.[dbo].[T1]

if you have databases on different servers than you have to create a linked server.

On second thought you can generate “create tables scripts” and run them on second database

Leave a Comment

tech