Command Line Utilities¶
BTR2SQL includes several command-line utilities installed in the bin directory of your BTR2SQL installation (<Program Files>\Mertech Data Systems\DB Drivers\Btrieve\bin). These tools handle migration, validation, and security tasks and can be integrated into scripts and automated workflows.
Command Line Utilities
Utility |
Description |
|---|---|
Migrates Btrieve tables to SQL using Data Definition Files (DDFs). Supports creating tables, copying data, generating INT files, and producing SQL scripts. This is the primary command-line migration tool. |
|
Migrates Btrieve files to SQL when no DDFs are available. Uses B_STAT to determine file structure. Intended as a last-resort proof-of-concept tool. |
|
Validates that data was correctly transferred from Btrieve to SQL after migration. Compares table structure, indexes, and record data. |
|
Encrypts passwords for use in mds.ini and INT configuration files. Supports both AES encryption and legacy encryption modes. |
Note
All utilities are located in the bin directory. If you run them from outside that directory, provide the full path or ensure the bin directory is on your system PATH.
Most migration utilities accept /server, /database, /user, and /password parameters. If these are omitted, the driver falls back to the mds.ini file, registry settings, or the Login dialog box — following the standard configuration precedence.