?
Solved

how to read BTrieve 6.x data

Posted on 2010-11-09
10
Medium Priority
?
880 Views
Last Modified: 2012-05-10
I need a way to read and extract data form .dat BTreive file.
0
Comment
Question by:novologik
10 Comments
 
LVL 13

Expert Comment

by:BCipollone
ID: 34098008
0
 
LVL 15

Expert Comment

by:DonConsolio
ID: 34098112
Btrieve 6 uses ISAM files and does not have a data dictionary.
If you are lucky you may also have  some .ddf files which provide
the data dictionary for easier access.

To read this file without .ddf files you need  the description of the
file structure (field types, length, name) to access the data.
Then you can write a program and export the data or create some
.ddf files if you have access to the needed tools (see post above).

If you have working .ddf files and you can access your data with
either with Xtrieve (old), Pervasive.SQL  (current BTrieve version)
or 3rd party tools.

The best solution probably is to export via the corresponding application
(if possible) or to write a small export program if you gave access to
the file description or .ddf files.
0
 
LVL 29

Expert Comment

by:Bill Bach
ID: 34098156
Here's another white paper to get you started:
    http://www.goldstarsoftware.com/papers/AccessingBtrieveDataFromODBC.pdf

It also includes a way to export the data from Btrieve format to UNF format -- which may take one more step out of the data transfer process.
0
Granular recovery for Microsoft Exchange

With Veeam Explorer for Microsoft Exchange you can choose the Exchange Servers and restore points you’re interested in, and Veeam Explorer will present the contents of those mailbox stores for browsing, searching and exporting.

 

Author Comment

by:novologik
ID: 34098265
Hi guys,

BCipollone: Thanks for the answer ...but those tools dosent work because I don't have BTrieve install on my machine.

DonConsolio: Yes I have all the ddf files and I'm able to read them with a third party software....I can read the data to but the third party sotware I used dosen't work very good when I read and export the data.... I tried with Pervasive 11 (the lastes version) I can read the dbf but not the data...maybe there's a to big difference with the data version.

BillBach: I take a look to the pdf and I will try the Pervasive version 9. I'll give you new later....

Thanks guys.....
0
 
LVL 29

Expert Comment

by:Bill Bach
ID: 34101968
The DDF's can be likened to a "transparency" overlay that defines the underlying Btrieve files.  If your DDF definitions don't match the Btrieve definitions, then you'll have all sorts of problems.  Check around and see if you can find a new set of DDF's (from the developer, if needed).  Note that PSQLv11 is current, and PSQLv9 won't give you any different results.  If the DDF's are bad, then you need new ones -- no question about it.

PSQLv11 also has a component called the "DDF Builder", and this can be used to either modify your existing DDF's or create new ones.  Having access to original source code is VERY helpful in this regard.

0
 

Author Comment

by:novologik
ID: 34102232
Yes...I understand....The developper is one of my competitor...I just sell my software to one of his customer....I need to access the data to transfer in my SQL Server database....I would like to be able to do that without contact them....!!!! I test with version 9 and it's not working....But I found a version of BTrieve (Pervasive SQL 2000) and I read that this version will be able to read the BTrieve data without any problem.

If I have the right version with DDF file, did I will be able to read them? If the DDF file are not perfert at 100% it will work are not?

Thanks
0
 
LVL 29

Expert Comment

by:Bill Bach
ID: 34102356
All versions of Pervasive PSQL *are* Btrieve.  Btrieve 6.15 was replaced by Pervasive.SQL 7, which was replaced by Pervasive.SQL 2000i.  Then came Pervasive.SQL V8, then Pervasive PSQL v9, Pervasive PSQL Summit v10, and now Pervasive PSQL v11.  They will all work the same way.  All can read the data, and all will require DDF's to read it directly from SQL.  

If the DDF's are CLOSE then you may be able to get most opf what you want.  If they are not close, then you'll be out of luck.  

As a developer, you have other options.  Instead of writing your own Btrieve application, though, use the BUTIL command to export the data to a UNF file, and then write your own application to parse the UNF file as described in the white paper.  Yes, this is a lot of work, but in the absence of DDF's, it is your only option.
0
 

Author Comment

by:novologik
ID: 34106895
Hi BillBach,

Do you have more information about the BUTIL command? I think I will need to go through that big process because the DDF files are not perfect and somme infomation cannot be transfer correctly.

P.S.: I use BTSearch 2009 ... it work fine ....only if your DDF files are perfect.
0
 
LVL 29

Accepted Solution

by:
Bill Bach earned 2000 total points
ID: 34106948
The white paper I mentioned above describes it.  Simply, the command is this:
    BUTIL -RECOVER <datafilename> <unffilename>

When done, you'll have a UNF file that you can parse by writing your own application.  Without valid DDF's, it'll be up to you to parse the data properly, figuring out what each byte in the record structure means.  This is no easy task, but it IS possible with some perseverance and (sometimes) good guesswork.
0
 

Author Comment

by:novologik
ID: 34140712
I finaly find a guy in california who recreate the ddf files for me and after that everything work fine. That guy is the one who create BTSearch 2009 software!!!!!

Thanks every one!!!!!
0

Featured Post

Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this blog post, we’ll look at how ClickHouse performs in a general analytical workload using the star schema benchmark test.
How much do you know about the future of data centers? If you're like 50% of organizations, then it's probably not enough. Read on to get up to speed on this emerging field.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …
Suggested Courses

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question