How to copy data from one database table to another database table

I have face this situation several times while web server and local server updates, and finally i have find out the simple solution.

Here i have taken two databases,

1. SampleDb
2. MyDb

I am going to copy one table data from MyDb to SampleDb.

1. Right click on destination database (where to copy) SampleDb.
2. In Task --> ImportData
 
                 

3. It will open a new dialog window. Choose your  Source Database. Here my source database is MyDb and then click on Next Button.

4.Then Choose Your Destination Database. Here my destination database is SampleDb and then click on Next Button.

5. Click on Copy data from one or more tables or views. Then Click Next on Button

5. It will list out all the tables from your source database. Here my source database is MyDb. It has three tables. you have to select which table data you want to copy. you can select one or more table.

6. Check Run Immediately and then Click on Next button

7. Then click Finish button. It will execute the query, then you have a success message with How many rows was transferred to your destination database.

I don't have any data in this table2. so it show 0 rows transferred. Now you have to check your destination database.

You have successfully copy data from one database table to another database table.