Performs a full ("normal") validation of an UltraLite database, including:
ulvalid -c "connection-string" [ options ]
|-c "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.|
Express validation. Only perform table validation. This option provides a faster validation than normal validation
|-oa||Cancel the process if it identifies that the database was created by a previous version of UltraLite (which would cause the database to be upgraded).|
Open the database in read-only mode. UltraLite makes a copy of the original file, which you can then use to test your scripts without altering the database. Changes to the copied file are discarded upon completion.
If you are connecting directly from the desktop to a database already deployed to a Windows Mobile device, the parameter is not supported.
|-ou||Upgrade the database if it was created with an older UltraLite release.|
|-q||Set the utility to run in quiet mode. Suppress informational banners, version numbers, and status messages. Error messages are still displayed, however.|
|-v||Print verbose messages.|
Validating a database verifies the accuracy of the table meta-data and ensures the file has not been corrupted.
An example of an express validation of a database named sample.udb run in quiet mode.
ulvalid -c DBF=sample.udb -e -q
|Send feedback about this page via email or DocCommentXchange||Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0|