Import

To import tables from Database A on Server A to Database B on Sever B, you can follow the below steps:

• Right click on Server B -> Tasks -> Import Data… -> Next

• Select the Data Source as e.g. “SQL Server Native Client 11.0”, set the server name, select the source database -> Click on Next

• Select the Destination as e.g. “SQL Server Native Client 11.0”, set the server name, select the database -> Click on Next -> Click on Next

• Select the source tables you want to copy -> Next -> Next -> Finish

Export

Very similar to import