Results 1 to 5 of 5
  1. #1
    Join Date
    Aug 2004
    Posts
    20

    Unanswered: Upgrade From Pervasive SQL 2000 (v7.0) to v9.5

    Hi,

    Has anyone done an upgrade from Pervasive SQL 2000 to v9.5 and aware or encountered of any issues/limitations?

    Many thanks in advance for your input.

    _msd_

  2. #2
    Join Date
    Dec 2001
    Posts
    1,109
    Provided Answers: 4
    WHat interface does your application use (Btrieve,ODBC,etc)?
    As far as the engin itself, the install is fairly easy anfd straight forward. Make sure you update the clients as well as the server (if you're using client/server).
    Mirtheil Software
    Certified Pervasive Developer
    Certified Pervasive Technician
    Custom Btrieve/VB development
    http://www.mirtheil.com
    I do not answer questions by email. Please post on the forum.

  3. #3
    Join Date
    Aug 2004
    Posts
    20
    Hi mirtheil,

    Thanks for that info. To answer your question, here is our set up.

    - Base application is developed by a third party. I think they used Btrieve interface.

    - In-house applications are developed for purposes of query, reporting, replication to SQL Server, etc. The older ones uses Btrieve, the newer ones uses ODBC (ADO in code).

    You mentioned straight forward, how about on the table level, are they straight forward as well? Is there is special conversion required?

    _msd_

  4. #4
    Join Date
    Dec 2001
    Posts
    1,109
    Provided Answers: 4
    From a data perspective, you shouldn't need to do anything unless your data files are in v5.x format. PSQL v9.x doesn't write to v5.x files (only reads them).

    I would strongly recommend testing in a test environment before upgrading your production server. Just to be safe.
    Mirtheil Software
    Certified Pervasive Developer
    Certified Pervasive Technician
    Custom Btrieve/VB development
    http://www.mirtheil.com
    I do not answer questions by email. Please post on the forum.

  5. #5
    Join Date
    Aug 2004
    Posts
    20

    Thumbs up

    Hi mirtheil,

    Thanks a lot for the info. I'll definitely take your advise into consideration.

    _msd_

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •