If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > Pervasive.SQL > btrieve conversion to what SQL?

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 01-30-10, 15:03
johnbruno johnbruno is offline
Registered User
 
Join Date: Jan 2010
Posts: 1
Question 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.
Reply With Quote
  #2 (permalink)  
Old 01-30-10, 19:10
mirtheil mirtheil is offline
Registered User
 
Join Date: Dec 2001
Posts: 1,026
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
http://www.mirtheil.com
I do not answer questions by email. Please post on the forum.
Reply With Quote
Reply

Tags
btrieve, novell, sql

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On