Upgrading previous versions of UltraLite databases, requires that you:
Synchronize the data.
Disconnect all applications and administration tools.
Copy the database to your desktop computer.
You cannot connect to an older version of the database with any UltraLite 10.0.1 administration tools until you have upgraded the database.
The UltraLite schema is now part of the database rather than in a separate .usm file. This means that applications can no longer create a new database when a database connection cannot be made. Applications must deploy an initial database or programmatically create a database using new CreateDatabase functionality.
File formats have been consolidated as of version 10 of UltraLite. This means that most platforms can now share a database and as a result, Unicode characters are no longer required.
If you need characters that are not included in your chosen collation, you should encode your database with UTF-8. See UltraLite platform requirements for character set encoding and UltraLite utf8_encoding property.
Windows CE and desktop databases
If you are upgrading databases for either of these platforms and no longer need Unicode characters, do not UTF-8 encode the database. UTF-8 encoding can unnecessarily increase the size of your database.
As of version 10, all database passwords are case sensitive, regardless of the case-sensitivity of the database. Consequently, user IDs, passwords, and even trusted root certificates may not be preserved as you upgrade your database. You must add former user IDs, passwords, and trusted root certificates to new UltraLite database. The default DBA password for new databases is sql.
UltraLite database upgrade paths
UltraLite database upgrade tools