Post reply

Create an SQL DTS to transfer data to Pervasive table

  • May 10, 2006 at 12:14 pm

    #68799

    Hi

    Can I create an SQL DTS to transfer data from SQL 2000 to Pervasive 8.0 or 9.0 ? if yes  how ? Has someone done this before ?

    Thanks

    Akeelah

     

     

  • May 10, 2006 at 12:59 pm

    #637090

    I've never done that specifically but I've taken data from Pervasinve and populated a SQL table with it.  You just need to have the Pervasive ODBC driver installed and create a DSN to talk to your Pervasive server.

    To help us help you read this[/url]For better help with performance problems please read this[/url]

  • May 10, 2006 at 1:13 pm

    #637093

    Thanks

    I was able to create a DTS and copy my tables from SQL to  Pervasive using " Other (ODBC data Source) "  connection.

     Akeelah 

     

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply