Copy tables from one database to another in SQL Server

Deepak Ratan

11y1.1kSQL

Copy tables from one database to another in SQL Server

I have a database called FirstDatabase and a database called SecondDatabase. I have a 40 table's in FirstDatabase that I want to COPY (data and all) from FirstDatabase to SecondDatabase. What is the SQL statement to do this?

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Raja T11y ago
Hi,

Please checkout below URL....

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/
Rajeesh Menoth11y ago
Hi Deepak Ratan,

Check this below articles :

1) http://stackoverflow.com/questions/187770/copy-tables-from-one-database-to-another-in-sql-server

2) http://www.codeproject.com/Tips/664327/Copy-Table-Schema-and-Data-From-One-Database-to-An
Govinda Rajulu Yemineni11y ago
Hi Deepak,

You can use this URL, it will satisfy your requirement

http://www.quora.com/How-do-I-copy-all-the-tables-in-one-database-into-another-database-using-SQL
Manoj Bhoir11y ago
Hi,
SQL Server Management Studio's "Import Data" task (Right-Click on the DB name, then Tasks) will do most of this for you. Run it from the database you want to copy the data into.

If the tables don't exist it will create them for you, but you'll probably have to recreate any indexes and such. If the tables do exist, it will append the new data by default but you can adjust that (edit mappings) so it will delete all existing data.