Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere 16 - Changes and Upgrading » How to upgrade to SQL Anywhere 16 » UltraLite upgrades


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.


  • 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.

  1. 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.

  2. 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.

  3. Check the generated XML file to verify the setting of the UTF-8 encoding.


The UltraLite database is upgraded to the latest version.

 See also