|
Performs a full (normal) validation of an UltraLite database.
ulvalid -c "connection-string" [ options ]
| Option | Description |
|---|---|
| @ data | Use this to read in options from the specified environment variable or configuration file. If both exist with the same name, the environment variable is used. |
| -c "connection-string" OR --connect="connection-string" |
Required. Connect to the database as identified in connection-string. If you do not specify both a user ID and a password, the default UID of DBA and PWD of sql are assumed. |
| -e OR --express |
Express validation. Only perform table validation. This option provides a faster validation than normal validation. |
| -q OR --quiet |
Set the utility to run in quiet mode. Suppress informational banners, version numbers, and status messages. Error messages are still displayed, however. |
| -v OR --verbose |
Print verbose messages. |
| --log=filename | Log operations to the specified file. |
| -? OR --help |
Displays utility usage information and exits. |
Validating a database verifies the accuracy of the table metadata and ensures the file has not been corrupted.
The validation includes:
Validate all database pages, using checksums when enabled. Certain critical pages always have checksums and even pages without checksums undergo a basic validity check.
Validate table(s) by checking that the table row count matches the count in each index.
Validate indexes by checking that entries refer to valid rows. ulvalid -e performs an express check, which includes only table validation.
An example of an express validation of a database named sample.udb run in quiet mode.
ulvalid -c DBF=sample.udb -e -q