To make schema upgrades, use the SQL statement ALTER DATABASE SCHEMA FROM FILE.
Do not reset a device during a schema upgrade. If you reset the device during a schema upgrade, data will be lost and the UltraLite database marked as "bad."
To upgrade the UltraLite schema
Create a SQL script of DDL statements that define the new schema. The character set of the SQL script file must match the character set of the database you want to upgrade.
You should use either ulinit or ulunload to extract the DDL statements required for your script. By using these utilities with the following options, you ensure that the DDL statements are syntactically correct.
If you do not use either ulunload or ulinit, review the script and ensure that:
Backup the database against which the upgrade will be performed.
Run the new statement. For example:
ALTER DATABASE SCHEMA FROM FILE 'MySchema.sql';
Because Ultralite error callback is active during the upgrade process, you are notified of errors during the conversion process. For example, SQLE_CONVERSION_ERROR reports all values that could not be converted in its parameters. Errors do not mean the process failed. The final SQL code after the statement returns is a 130 warning in this case. These warnings describe operations of the conversion process and do not stop the upgrade process.
|Send feedback about this page via email or DocCommentXchange||Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0|