Use DTS to Export SQL Server Tables into Remote DBMSs via Virtuoso VDB

PART I: Identify & Review Structure of SQL Server Tables

1. Launch the Microsoft SQL Server Enterprise Manager.

2. Expand the Microsoft SQL Servers-->SQL Server Group-->Instance menu tree.

3. Expand the Databases folder.

4. Expand the menu tree associated with the SQL Server database that contains the tables that you want to replicate.

5. Click Tables.

6. Click the table names of any tables that you want to replicate.

7. View the table definitions for tables that you want to replicate.

8. Expand the SQL Server Enterprise Manager's Tools menu.

9. Double-Click the SQL Query Analyzer.

10. Execute a select * from the table that you want to replicate.

11. Click the > icon to execute the query.

12. Review the result set produced by the query.

13. Exit the SQL Query Analyzer.

14. Exit the Microsoft SQL Server Enterprise Manager.

Proceed to Part II: Prepare & Test your ODBC Data Sources