Upgrading an UltraLite database (Linux)

For users of previous versions of the software, this task summarizes the process of rebuilding your database to version 16.

Prerequisites

Install the version of SQL Anywhere that created the database.
Make a backup copy of your existing UltraLite database.
Synchronize your database if it is a production database that may contain unsynchronized changes.

Context and remarks

UltraLite version 16 cannot read UltraLite databases created using any prior version of the software.

Create an XML file (or files) with the contents of the database.

At a command prompt, go to %SQLANY%/bin32—where %SQLANY% is the location of your earlier SQL Anywhere install—and then use the ulunload utility on the databases.
Use the UltraLite version 16 ulload utility, or use the Load Database Wizard in the UltraLite 16 plug-in for Sybase Central to load the schema and data into a new version 16 database.

UltraLite databases now default to the UTF8 encoding. If this encoding does not suit your needs, you should explicitly set the utf8_encoding parameter to off.
Check the generated XML file to verify the setting of the UTF-8 encoding.

Results

The UltraLite database is upgraded to the latest version.