Using MS SQL 2000 DTS to Export Data
Customers with Microsoft SQL 2000 Enterprise Manager
installed on their computer have a powerful way to interface
with the SQL Server. The DTS (Data Transformation Service) also
allows you to import and export to any data type. This example
should serve as a starting point on how to move a database from
one SQL server to another. You might want to tweak the options
to better suit your situation.
To connect to you database and start working on it, you will
a. SQL Server IP Address
b. SQL Server Login ID and Password
c. SQL Server database Name
Open Enterprise Manager. Select menu choice, Start -> Program
Files -> Microsoft SQL Server -> Enterprise Manager
After Enterprise Manager starts up, and Click on "SQL Server
Group". Right click on Database, select "All Tasks > Export
The DTS Wizard will start. Click on "next"
a. Enter the IP address of the source SQL Server
b. Select "Use SQL Server Authentication
c. Enter User Name and Password
d. Select the Source Database
e. Click on "Next
you have any questions:
support@ITsGroup.org or Phone 1-780-701-7282.