Upgrading databases created with previous versions of UltraLite

The UltraLite file format changed between versions 9 and 10 and then again between versions 11 and 12. UltraLite version 12 cannot read UltraLite databases created using any prior version of the software.

Notes

Databases can only be upgraded on the desktop
Make a backup copy of your database
Synchronize your database if it is a production database that may contain unsynchronized changes

Upgrade an UltraLite database on Windows

If the database was created with version 9 or earlier versions of UltraLite, open a command prompt and go to %SQLANY12%\UltraLite\Unload\V9.

If the database was created with version 10 or 11 of UltraLite, open a command prompt and go to %SQLANY12%\UltraLite\Unload\V11.
Run the ulunload utility to create an XML file (or files) with the contents of the database.
Use the ulload command line utility, or use the Load Database Wizard in the UltraLite plug-in for Sybase Central to load the schema and data into a new version 12 database. Note that UltraLite databases now default to UTF8 encoding. If this does not suit your needs, you may need to explicitly set the utf8_encoding parameter to off.
Check the generated XML file to verify the setting of the UTF-8 encoding. See UltraLite utf8_encoding creation parameter.

Upgrade an UltraLite database on Linux

Open a command prompt and go to $SQLANY12/ultraLite/unload/v11.
Run the ulunload utility to create an XML file (or files) with the contents of the database.
Use the ulload command line utility, or use the Load Database Wizard in the UltraLite plug-in for Sybase Central to load the schema and data into a new version 12 database. Note that UltraLite databases now default to UTF8 encoding. If this does not suit your needs, you may need to explicitly set the utf8_encoding parameter to off.
Check the generated XML file to verify the setting of the UTF-8 encoding. See UltraLite utf8_encoding creation parameter.

Discuss this page in DocCommentXchange.