Export Pervasive.SQL into SQL Server 2000

• PFlorenzano

  SSCrazy

  Points: 2180

  More actions

  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
  

• Linda Johanning

  SSCertifiable

  Points: 6727

  More actions

  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