• Topic
  • Discussion
  • VirtuosoWikiWeb.DTSExportViaVDBp3(Last) -- Owiki? , 2016-08-19 15:01:34 Edit owiki 2016-08-19 15:01:34

    1. Launch the DTS Import & Export Wizard.

    2. Click the Next button.


    3. Use the first Data Source dialog to configure a connection to SQL Server.


    4. Use the Destination Drop-down to select the OpenLink OLE DB Provider for Virtuoso.

    5. Click the Properties button that appears.

    6. Use the Hostname field to pass the hostname and listen port of your Virtuoso instance.

    7. Use the User name and Password fields to provide your Virtuoso DBA authentication information.

    8. Use the "Select the database" drop down menu to select the Virtuoso VDB schema that will hold your linked in tables.

    9. Test your Destination Data Source configuration.

    10. Click Next.

    11. Click the Copy table(s) radio button.

    12. Scroll through the tables list box and check the table that you want to export.

    13. Check "Run immediately" and proceed to the next dialog.

    14. Click Finish.

    15. Wait for confirmation of table replication to occur.

    16. Click Done.


    Proceed to Confirm Virtuoso Table Replication


    Referenced by...