Pervasive

Hi,

We have recently migrated to v10. We have been rebuilding our files but because of the time it takes we cannot do them all at once. We are now near the end and would like to determine which tables need rebuilding. Is there a tool that will list all the tables indicating which Pervasive version they are?

TIA

Adam

 Yes.  Use this command for each individual file:

    BUTIL -STAT <filename>

And look for the File Version line.

You can also use our ListStat tool, available from www.goldstarsoftware.com/tools.asp, with a command like this:

    LISTSTAT *.* /MCF

This will give you a comma-delimited list of files and their  respective versions.  (Add other command line switches to get things like record counts, too.)

Or, our BtrvInfo tool (same web page) can be used in a batch script iterating over your files.  Use the command "BTRVINFO /VE" to return the file version into the ERROR_LEVEL batch file variable.  You can then use an IF statement to check the ERROR_LEVEL coming back and branch to a rebuild function if the return code is less than a specific value.

Perfect, thanks Bill