Hello,

we have lots of pre 7.x btrieve database files in different folders and are upgrading to pervasive v9.

is there a tool or a way how we can find out which of the database files are pre 7.x so we can convert them all in one step with the rebuild tool ? our problem is we have so many different database files with different version, that we need to get an overview of which files are incompatible with v9, because looking into every single database with the maintenance tool is kind of impossible.

thanks in advance.

gsnetwork 

Grab a copy of our ListStat tool, available either in the Pervasive ComponentZone, or from our web site at www.goldstarsoftware.com/tools.asp.  ListStat allows you to do a pre-upgrade scan of files.  I recommend the /2 option, which displays the File version, Page Size, and Record Count from each file in a comma-delimited format.  To scan all subdirectories, add the /S option, and maybe the /W option.  You command will probably look something like this:

    LISTSTAT *.BTR  /2 /sw
 The 30-day trial should be plenty for a simple migration.

By the way -- if the files are 6.x format, then they are OK for use with PSQLv9 and PSQLv10 -- only Btrieve 5.x files will not work correctly.  There are other reasons for rebuilding, of course, like performance, but 6.x files will still work.

Thank you sooooo much Bill, this is exactly what we were looking for. Awesome !

Have a nice weekend.