Copying Tables From One Database To Another Database

In this blog I am going to explain how to copy tables form one data base to other database in SQL Server 2008 R2

I am going to explain how to copy table from one database to other database with an example as shown below.

Example: Suppose there are two Databases Bank Database and Customer Database  and the table description for the two database and their tables are as follows.
 

Bank Database Tables: 

• Account
• Loan 
• Depositor

Customer Database Tables:

• Details
• Branch
• Address                

If you want to copy Branch Table From Customer DB To Bank DB then write the following query:
 

SQL Query: 

Select * INTO Bank.dbo.Branch 

From  Customer.dbo.Branch

Now, Branch table from customer DB will be copied to Bank DB