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

(Page 1 of 5 )

DTS, an integral part of MS SQL 2000 server, moves data very easily between MS SQL Servers and between Microsoft products. However, it can also reliably move data to and from non-Microsoft databases. Although DTS requires a Microsoft license, it can be implemented independently of MS SQL 2000 Server. This step-by-step, how-to tutorial describes the process of moving data between MS SQL 2000 Server and Sybase's SQL Anywhere server. The key interface required for this is either a OLEDB or a ODBC compliant driver. Although the DTS designer is a better tool than the Import/Export wizard, we will be using the wizard.

In this tutorial all the steps will be shown for importing from or exporting to the Sql Anywhere database, and since the steps are essentially the same only   few steps will be shown for importing into SQL Server. The reader must review the previous tutorials to get a better handle.

Tables in SQL Anywhere and MS SQL 2000 before Import/Export

The following two pictures show screen shots of the databases with tables showing in their respective administrative user interfaces, the Enterprise Manager for MS SQL 2000 server and the Sybase Central for the SQL Anywhere server (version 9.02). The publishers table from MS SQL Server will be moved to the ASAdemo.db on the SQL Anywhere Server, and the department table from the SQL Anywhere will be imported into the pubs database in MS SQL Server.

 

Next: Initial preparation before calling DTS >>
 

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!