Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2010

    Question Unanswered: btrieve conversion to what SQL?

    We are planning a conversion from Novell / btrieve to a Windows server and are researching which database to use. Our current considerations include MS SQL server, MySQL or Pervasive SQL. Our applications are internally developed using VB6, Cobol and Fortran. The program library consist of hundreds of programs that call btrieve routines to get access to the data. Although we have created the ddf's to use with VB6, we don't use the ddfs on a regular basis. I believe we can convert the data to SQL easily but my concern is to minimize the application code modifications. Is it possible to use Pervasive SQL and the btrieve API without having to rewrite the code? Any insite would be greatly appreciate.

  2. #2
    Join Date
    Dec 2001
    Provided Answers: 6
    Yes, you can use applications developed using the Btrieve API with Pervasive.SQL. PSQL also adds an ODBC (and other methods) but the core is still Btrieve.
    The only caveat would be if your data files are v5.x format. PSQL v9 and later only support writing v6.x and later files. Converting the data files to a newer format is easy with either a command line or GUI Rebuild tool.
    Mirtheil Software
    Certified Pervasive Developer
    Certified Pervasive Technician
    Custom Btrieve/VB development
    I do not answer questions by email. Please post on the forum.

Tags for this Thread

Posting Permissions

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