Hello
We're porting our legacy systems to Java and relational databases, but
in the meanwhile, NetWare 3.12 is still running (with BTrieve 6.15). As
most of the system still runs on it, when the new app must acquire data
from a btrieve database, our engineers export a text file (which is
updated everyday) and the new app reads that file. That's not great,
but it works.
Buying pervasive sql is not an option, as we chose to use the money to
rewrite the app, so I wondered if anyone knew how to access btrieve
files directly (only READ operations will occur, so that shouldn't be
destructive). Could be written in any language that compiles on linux
(need the source code tough).

Thanks in advance,

Guilherme Barile

Hi Guilherme,

In considering all the options I could think of, it's my opinion that
all options are at least as expensive as buying a 6-user Pervasive.SQL
license.

All options require that you know the record structures, which I assume
you must since you're successfully extracting the data from the
unformatted files now.

Probably the cheapest option I can think of is to buy one Workgroup
Engine seat create the DDFs for the data files you want to extract,
make a daily backup of the existing database, convert the data in the
backup to v9 format, and then you can run an ETL process with any
ODBC-compliant application. This requires a Windows box, however, as
there's no Workgroup Engine for Linux

Another option along the same lines is to buy a 6-user Pervasive.SQL
license for Linux and do the same things as I suggested in the previous
paragraph.

In short, you need a Btrieve or Pervasive.SQL engine to access Btrieve
files.

Wayne Freeman
www.analyticabiz.com
A Pervasive Premier VAR

guigouz ha scritto: