MigrationValidator

Warning

MigrationValidator is no longer included with BTR2SQL as of version 7.0.10826.0. The same validation functionality is now available through the MdsMigrateTable (/validate-data) and MdsMigrateFile (/validate-data) command-line tools.

MigrationValidator verifies that data was correctly transferred from a Btrieve application to an SQL server after migration. It checks that the basic table structure and indexes match, then reads all records from both Btrieve and SQL to verify the data was successfully stored. A message is displayed if any mismatch is found.

Prerequisites

  1. BTR2SQL or another tool has copied all data from the Btrieve database to the SQL backend.

  2. The data has not been modified in either version of the database since the migration. Otherwise, the tool will incorrectly report failures such as mismatched data or incorrect row counts.

  3. The Pervasive version of w3btrv7.dll must be present on the system PATH. You can accomplish this by copying the original DLL from your pvsw\bin folder into the folder where MigrationValidator.exe is located.

Command-line Syntax

Run MigrationValidator from a command prompt:

MigrationValidator <database location> [-dll <Mertech dll>] [-table <tablelist>] [-maxRows <n>] [/varOnly] [/debug]

Parameters

Parameter

Description

<database location>

Required. Path to the DDFs. The DDFs are read for schema information, then each table in the list is opened and tested.

-dll <Mertech dll>

Full path and filename (wbtrv32, w3btrv7, or sql_btr) of the DLL used to access the SQL backend. If not specified, sql_btr.dll is loaded from the system PATH.

-table <tablelist>

Table(s) to test. By default, all tables are tested. Specify one or more table names separated by semicolons, or include the -table parameter multiple times.

-maxRows <n>

Limit the number of rows checked per table to shorten testing time.

/varOnly

Only test tables with variable-length records.

/debug

Display additional processing information.

Example

MigrationValidator c:\mydata\demodata -dll "C:\Program Files\Mertech Data Systems\DB Drivers\Btrieve\bin\ora_btr.dll" -table person;billing;class -maxRows 2000

See Also