Deciding between SQL Anywhere and UltraLite

QAnywhere client applications can now use an UltraLite database as the client message store. This provides a lighter-weight solution for pure messaging applications on mobile devices. A pure messaging application means an application that uses store and forward messaging, but not data synchronization.

Some of the key advantages of UltraLite are:

It has a smaller application footprint and does not require full SQL Anywhere installation.
It has a smaller process footprint. QAnywhere Agent requires only 3 processes instead of 4 (uleng12, dblsn, and qauagent instead of dbeng12, dbmlsync, dblsn, and qaagent).

UltraLite limitations

Keep in mind the following limitations of UltraLite when deciding between SQL Anywhere and UltraLite:

There is no support for "ESCAPE" keyword in transmission rule condition syntax.
There is limited support for property attributes. You can only use property attribute functionality with the predefined property ias_Network.

Deciding between SQL Anywhere and UltraLite

UltraLite limitations

Recommendation

See also