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

SQL Anywhere 11.0.1 » SQL Anywhere 11 - Introduction » SQL Anywhere 11 Overview » Overview of data management technologies

 

Choosing between SQL Anywhere and UltraLite databases

SQL Anywhere and UltraLite address data storage and data access needs from large enterprise database sources to small, mobile databases. When designing an application, you need to choose the database that is the right fit.

  • If your target platform is Unix or Mac OS X, you must use a SQL Anywhere database.

  • If your target platform is the Palm OS, BlackBerry, Embedded Linux, Windows Mobile 6, or Java ME smartphones, you must use an UltraLite database.

  • If the target platform is Windows Vista, Windows XP, or Linux, both SQL Anywhere and UltraLite are available. SQL Anywhere is often preferred because provides a fuller feature set and its additional memory requirements are rarely an issue.

  • If the target platform is Windows Mobile, such as on a Pocket PC or smartphone, you need to consider memory constraints, and possibly the tasks your application needs to perform. On Windows Mobile, SQL Anywhere requires approximately 6 MB of memory plus another 2 MB for the synchronization component, whereas UltraLite requires less than 1 MB and has synchronization built in. But, while UltraLite is considerably smaller, it does not offer the same support as SQL Anywhere for such things as complex queries, events, procedures, triggers, views, and so on.

Your overall solution may result in a mixture of SQL Anywhere and UltraLite databases, synchronized using MobiLink.

For more information about the differences between the core database solution (SQL Anywhere) and the UltraLite database solution, see UltraLite feature comparison.