%META:TOPICPARENT{name="IntegrateMigrateWVirtuosoVBD"}%

==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. %BR%
2. Expand the Microsoft SQL Servers{{{--}}}>SQL Server Group{{{--}}}>Instance menu tree.%BR%
3. Expand the Databases folder.%BR%

<img src="%ATTACHURLPATH%/part1_img1.png" style="wikiautogen"/>

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

<img src="%ATTACHURLPATH%/part1_img3.png" style="wikiautogen"/>%BR%

5. Click Tables.%BR%

<img src="%ATTACHURLPATH%/part1_img4.png" style="wikiautogen"/>%BR%

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

<img src="%ATTACHURLPATH%/part1_img6.png" style="wikiautogen"/>%BR%

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

<img src="%ATTACHURLPATH%/part1_img7.png" style="wikiautogen"/>%BR%

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

<img src="%ATTACHURLPATH%/part1_img8.png" style="wikiautogen"/>%BR%

9. Double-Click the SQL Query Analyzer.%BR%

<img src="%ATTACHURLPATH%/part1_img9.png" style="wikiautogen"/>%BR%

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

<img src="%ATTACHURLPATH%/part1_img10.png" style="wikiautogen"/>%BR%

11. Click the > icon to execute the query.%BR%

<img src="%ATTACHURLPATH%/part1_img11.png" style="wikiautogen"/>%BR%

12. Review the result set produced by the query.%BR%

<img src="%ATTACHURLPATH%/part1_img12.png" style="wikiautogen"/> %BR%

13. Exit the SQL Query Analyzer.%BR%
14. Exit the Microsoft SQL Server Enterprise Manager.%BR%


Proceed to [[DTSExportViaVDBp2|Part II: Prepare & Test your ODBC Data Sources]]