How to copy tables from a database to another in SQL Server ?

Published on August 29, 2016 by Senthil Kumar

Filed under SQL Server

Last modified August 29, 2016

Print this page

rate 1 star rate 2 star rate 3 star rate 4 star rate 5 star
Your rating: none, Average: 0 (0 votes)

This article have been viewed 7168 times

There are times when you may want to copy the tables from one database to another along with the data or import data along with the schema in SQL Server. One of the ways to do this is using the SQL Server Import/Export Wizard.

How to copy tables from a database to another in SQL Server ?

1. Launch SQL Server Import and export wizard from the Windows Start menu.


2. Select the source from which you want to copy the data from and click the next button.


3. Specify the destination data source to which you want the data to be copied to and click the next button.


4. Select the “Copy data from one or more tables or view” radio button and click next button.


5. Select all the tables via the checkbox before the table names from the source column and click Next button.


6. Enable the checkbox “Run immediately” and click “Next button.


7. In the next step , click the finish button. The copying of the tables from the source database to the destination database should start immediately and within few mins you should see the copying complete.


Leave a Comment


You might be Interested in these Posts

How to perform Shallow Copy in C# ?

To perform Shallow copy in C# , you can use the this.MemberwiseClone() method. How to perform Shall...

How to copy array and increase size dynamically in Java ?

Below is a sample code snippet in Java demonstrating the steps to copy the array elements to a new a...

How to Perform Inner Join using LINQ in C# ?

Are you looking for the syntax on how to perform inner join using LINQ in C# ? . Below is a sample c...