btrieve with variable-length data

Posted November 4th, 2009 by sokchamv

Hello

Are there any tools that can parse or load to another format (for example ms sql) a btrieve database which contains variable-length data ?

I actually have an old btrieve database and I don't have any documentation related to the structure of this file so I need a tool that will automatically parse or load into another database.

Any help would be appreciated. Thanks.

‹ Field truncation on multi line field Problem when exporting a CSV file ›

RE: btrieve with variable-length data

On November 4th, 2009 jterrell said:

Hi sokchamv,

None of the DataTools products can meet your project requirements...sorry.

However, you may be able to work with your data by performing multiple steps. Here are some suggestions:

Use the utilities that are available in Pervasive.SQL to update your existing data files to a newer version; i.e., from v6 to v10.

Use the utilities that are available in Pervasive.SQL to create Data Dictionary Files (DDFs) that contain the data field and record structure definitions for each of your data files.

You can learn more about Pervasive.SQL here:
http://www.pervasivedb.com/Database/Products/Pages/PSQLOverview.aspx

- Jo