Using DTS: Import From/Export To a Non-Microsoft Database - Initial preparation before calling DTS

(Page 2 of 5 )

Before you move tables from one system to the other, you need to make some initial preparations to the system so that the operation completes without a hitch.

Start MS SQL Server and Enterprise Manager

The MS SQL Server must be started since we are operating with its database. Also for visualizing and verifying transfer, the Enterprise manager should be running, although it can be started when needed.

Start SQL Anywhere Server and Sybase Central User Interface

SQL Anywhere server must be started, and Sybase Central, which is the counterpart of the Enterprise Manager, must be started and connected. The SQL Anywhere server can be started from Start ->All Programs ->Sql 9 Anywhere ->Adapter Server Anywhere ->Network Server Sample. For details about this please review my previous article. You should see the following screen when the server starts.

Sybase Central can be launched by following the trail, Start -> ALL Programs-> Sql 9 Anywhere ->Sybase central. When it is launched it is not connected to the server as shown here.

You can connect to the server started in the previous step by using the drop down in the file menu, File -->Connect. When you click on connect, you will face the following window which requires authentication. For username enter dba and for password enter sql and click OK.

Clicking on the Database tab, the next screen will be shown. If you click on Find..., the dropdown should show the asademo9 server, assuming you have started the database server. The database is identified by a file name in the C: directory, and therefore you may browse to that file. In the present example the complete path to the directory is C:\Program Files/Sybase/SQL Anywhere 9/asademo.db.  Enter the same information in the dropdown marked Start Line: Please refer to the previous tutorial for other details.

Next: Create a File DSN for SQL Anywhere >>
 

More MS SQL Server Articles
More By Jayaram Krishnaswamy

Comments On: Using DTS: Import From/Export To a Non-Microsoft Database

· Come read the article and comment! The method is quite generic. You can...    · Hi, You say that DTS can be used independantly of MS SQL Server but how would you...    · Hi skippy:Try this free download of MSDE [Download Microsoft SQL Server 2000...    · How do we cary over the primary keys when porting data from sybase to sql...    · I am just returning from a vacation, and I will try to show it through a demo...   >>> Post your comment now!