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