• BTRIEVE::SAVE

I've been looking for the same thing, and the BTRIEVE module in CPAN only supports "SAVE" files, and specifically does not support the "other 12 documented formats"... apparently including ".BTR" files (which is what I need a parser for). My fix is to install Pervasive on my computer and extract the database into a CSV and have Perl parse and inject that into our target db. That, or see if there's a Pervasive JDBC driver and do it in Java. Or maybe this is an excuse to learn Python. Or...

Yea, got it. I've looked at it before. I still may be able to use it in this app. What I'm lookin' to do is pull the data from a Win32 system DSN into another Win32 system DSN (use appropriate SQL here). I'm trying to do something without using DBI, but there may be no way around it. "Licenses.....We don't neeed no steeeekin' licenses....

Nat

Unless the the purchased company has a Pervasive DB engine you can use, there is the option of downloading a 30-day evaluation copy of the workgroup engine directly from the source.

Then you can use DBI and DBD::ODBC to access the database, works pretty well IMHO. You can open connections simultanously to the purchased database and your current database, hence moving data in one step.

The only cinch is that you need the database description files (.DDF) to be able to use the SQL interface. Otherwise you will have to resort to dumping table data to disk using the BUTIL utility, and then use perl and substr | unpack to parse the asciifiles, yuck.

So, check if the purchased company used the MKDE interface(bad for you) or the SRE (good for you) before anything else.