The following describes the procedure to import data into another server SQL Server Management Studio.

Before beginning, you need to connect both database servers.

Step 1: Connect to the database server that you want to import from.

connect database

Step 2: Create an empty database.

create new database

Step 3: Provide a name for the new database and click OK.

type database name

Step 4: Right-click the new database then seelct Tasks > Import Data.

import data

Step 5: Click Next.

click next

Step 6: Select the source.

sql server native

Step 7: Select the source.

select server name 

Step 8: Select the destination database part 1.

choose a destination 

Step 9: Select the destination database part 2.

user name password

Step 10: Select the first option.

copy data

Step 11: Select the objects you want to import.

select table 

Step 12: Then click Next.

select source table

Step 13: Click Run immediately then Next.

run immediately

Step 14: Check the summary then click Finish.

finish

Step 15: Wait until the process completes. Then close.

process