Copy tables from one database to another in SQL Server

Question

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 First Database that I want to COPY (data and all) from First Database to SecondDatabase . What is the SQL statement to do this?

Raja T · Answer

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 Menoth · Answer

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 Yemineni · Answer

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 Bhoir · Answer

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.