- Login to the connection
- Right click on the Database Name
- Select Tasks
- Select Export Data
- Select Data Source Server Name and Database Name
- Select Destination Server ( if you dont see your server name , add it manually) and Database Name
- Then Select Copy Data from one or more tables or views
- Then Select The Source Table you want to copy the data from Note : Change the Table Name if you are copying it to same Database
- Then Select Next , check Run Immediately
- Click Finish
Now the table will be created and Data will be copied.
