MsSQL 2000 remote Import Export Server method

Suitable for installation with MSSQL2000 Database

1. Connect to the remote database server:

A:OpenMSSQLEnterprise Manager-----"SQL ServerGroup----"Right click------"NewSQL ServerRegister(I)-Next Step----"Enter the database under the available serverIPaddress such as1.1.1.1-----"
Click Add and Next -----Click the SQL SERVER login Information assigned to me by your system administrator and next ---- Enter the database name and password
Click Next ----continue to click Next until you finish

2. import the local database to the remote database :

Open the database server you just established, such as 1.1.1.1------"point Open database -----" Find the database name -----"right ------ "Import data in All Tasks
-----"Next ----" To select the data source page ------Server, the default local point to make
with SQL Server authentication, user name password input, number
Select the original database name you want to import , then next ----Select your remote number
according to the library's IP.----point using SQL Server authentication , Enter the database in the user name
name , password, and then next ---"dot in SQL
copy objects and data between the Server databases, next, and then default to the next step until completion , the local computer's database is automatically copied to the remote database.

Positive Dragon Data center: zlnic.net
Enquiry Line: 15991722597

ask q q: 2954598210

Head Office Address: 7028 room , West LAN Road, Xianyang, Shaanxi Province, China

Xi ' an branch: Xi ' an high-tech zone science and Technology road Safir Building

MsSQL 2000 remote Import Export Server method