SQL Server 2005 How to import a remote database to a local _mssql2005

Import and export between the remote database and the local database data is always a matter of concern.

Below, I'll give you a detailed introduction to SQL2005 the method of importing a remote database to a local.

First, open the SQL2005. The method is: "Start" → "program" → "Microsoft SQL Server 2005" → "SQL Server Management Studio" so that you can open the local SQL2005.

After opening the local SQL2005, how can I now import the database from the remote database into the local SQL2005?

Like the following figure, find the "system database", in any database above such as model above right click, select "Task" → "Import data."

Next, a dialog box pops up, clicks Next, and comes to the dialog below.

The dialog box above, you choose a data source, refers to the selection of remote database data , note that the above dialog box, refers to the remote database.

At the ① location, enter the IP address of the remote database, and then select Use SQL Server Authentication to fill in the user name and password separately at ② and ③.

Finally, the database is where the ④ is, choosing which database of the remote server you want to select. All set up, click "Next", come to the setting of the figure below.

The dialog box above refers to the settings for the local database .

Server name there, generally use the default can, if you have more than one name, you can also choose, and then, set the login local database username and password.

Finally, select a local database name in the database, and if not, click the "New" button to create a new database name.

Then click "Next" to see the image below.

In general, if you want to replicate all the data in a remote database, select "Copy data from one or more tables or views", or select the following. Then click "Next" and come to the next picture.

In the diagram above, the database table of the remote database you selected appears in the list, click "Select All" and click "Next" to eject the following image.

In the illustration above, you will typically select "Execute Now" only, and you may not select Save SSIS package. Then click the "Finish" button.

In this way, you go to the remote database data transfer to the state of the local information, you will see how many, the total number of successful information. If it is completely successful, the remote database is successfully imported to the local area.