Upgrading an UltraLite database (Windows)

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

Prerequisites

If you are upgrading from an UltraLite version 9 or earlier database, you must have that version of SQL Anywhere installed.
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.

Open a command prompt, navigate to the directory of the earlier SQL Anywhere install, and then use the ulunload utility on the database.

If the UltraLite database was created with version 10, 11, or 12 of SQL Anywhere, you can, alternatively, open a command prompt, go to the %SQLANY16%\UltraLite\Unload\ directory, choose the directory that applies to your version of the UltraLite database, such as V10, V11, or V12, and then use the ulunload utility from that directory.
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.