Post
Ask Question

Import Data to Another Server

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


Similar Articles