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 (Windows)

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


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

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

  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