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.

Prérequis

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.

Contexte et remarques

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.

Résultat

The UltraLite database is upgraded to the latest version.