UltraLite upgrades

Consider the following notes prior to upgrading to an UltraLite version 16 database:

UltraLite version 16 cannot read UltraLite databases that were created using previous versions of the software.
You cannot upgrade databases on devices.
Once the database is upgraded, it cannot connect to prior versions of the applications, utilities, and software.
If you have multiple versions of SQL Anywhere on your computer, pay attention to your system path to ensure that you are using the appropriate utilities. UltraLite utility names are the same between versions, and only the directory path name sets them apart from each other.

Before using existing applications with this version of the software, be sure to review the list of new features and behavior changes to determine whether your application is affected.

Upgrading version 12 and earlier databases

UltraLite version 12 and earlier databases must be unloaded into a SQL or XML file using the version of the software that was used to create the database. Use the ulunload utility provided with that software.

If the older version of the software is not installed and you are using a Windows desktop operating system, you can use one of the older ulunload utilities that are included in SQL Anywhere version 16. Select the ulunload utility that is appropriate for your version of the UltraLite database.

Once the database is unloaded, use the version 16 ulload utility to load the XML file into a version 16 database, or the dbisql utility if you unloaded the database to a SQL file.

Upgrading version 12.0.1 Java edition databases

Compatibility with existing software

UltraLite 16 database files only support connections from version 16 client applications or the version 16 UltraLite engine.
The UltraLite version 16 runtime and the UltraLite version 16 engine do not work with database files and application code created with UltraLite version 9 and earlier.