View BTR and export BTR

[takyan]

hi, how can i view a BTR file using Pervasive?
and how can i export a BTR table to MS SQL Server?

pls advice

Takyan

 

[TomKane]

SQlScope allows export - assuming your using PSQL 7

BTSearch I think can do it - it's a third party product - I don't have any contact details

 

[Linda84]

The data from a Btrieve file can be exported to a flat/sequential file using any number of tools - you probably have BUTIL or the Btrieve Maintenace Utility, and both of these can export.

Keep in mind that Btrieve data is a series of bytes in a "record". It is not a well-defined set of fields where you know lengths, types, field names, etc. If you have a Btrieve file defined with records that are 100 bytes long (you can see this from a BUTIL -STAT operation), the export will write 100 bytes to the flat file. Some of these 100 bytes may be ASCII/string data, and therefore viewable. Some of these 100 bytes may be binary data (integers, IEEE floats, decimals, etc.) The export will not convert binary data to displayable strings, because the Btrieve file does not contain any information about field layouts. So, your export may contain unreadable characters. Linda
Pervasive Software Support

 

[grnelson]

As was mentioned above you can use BtSearch to export to dbase or ascii format which can then be imported into about any other format. You can download at

http://www.nssdd.com.

It does require that you have DDF files which are the file.ddf, field.ddf and index.ddf. If you do not have these then you have two options. One is to contact the original vendor to see if they will provide them or 2) you can use BtSearch32 to help you analyze the file and build the DDF.

Gil