Introducing SQL Anywhere Studio
The Architecture of Database Applications
Comparing Adaptive Server Anywhere and UltraLite
This section describes the complementary features of Adaptive Server Anywhere and UltraLite databases, to help you choose the most appropriate technology for your needs.
If you are deploying mainly to PCs, Adaptive Server Anywhere is built to meet your needs. If you are deploying to small devices such as the Palm Computing Platform, UltraLite will fit the bill. If you are planning to deploy on a platform supported by both technologies, such as Windows CE, you should consider the following issues.
Application type UltraLite database engines include only the code necessary to execute the tasks specified when your application is compiled, so you cannot use dynamic SQL to execute ad hoc queries against an UltraLite database. Further, each UltraLite database and database engine is for use by only a single application: if you want to use more than one application against a single database, you should choose Adaptive Server Anywhere.
Programming interface If you are happier using an interface other than Embedded SQL or Java, such as ODBC or OLE DB, and your target platform is not so resource-constrained as to require UltraLite, you can use Adaptive Server Anywhere.
Deploying across a variety of devices The programming model for UltraLite enables platform-independent database access code so that you can port the user interface to new platforms and devices without having to alter the underlying data access layer.