Post reply

Export Pervasive.SQL into SQL Server 2000

  • March 3, 2004 at 12:44 pm

    #65542

    Hello everyone,

    Has anyone every exported, data and objects, from Pervasive.SQL and imported it into SQL Server 2000?

    If so, what procedure do you follow?

    Any information would be greatly appreciated

    Peter.

    Peter M. Florenzano

    Database Administrator

  • March 4, 2004 at 1:36 pm

    #497391

    I found this to be the easiest way:

    Install Pervasive Client on the SQL Server and create an ODBC connection to the Pervasive data. 

    Create a DTS package and select "Other data source" then select the Pervasive DSN and destination to a SQL database. 

    The data import is quite easy plus you can modify the package and schedule it.  If you're looking to push the data from the Pervasive side, the method is limited.  You can only export text files and there is no scheduling tool.

    Good Luck.

    Linda

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

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