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

SQL Anywhere 12.0.1 » SQL Anywhere 12 - Changes and Upgrading » What's new in version 11.0.0 » UltraLite » UltraLite new features


Main features

  • Support for synchronization profiles   UltraLite 11.0.0 and 11.0.1 support synchronization profiles. See ALTER SYNCHRONIZATION PROFILE statement [UltraLite], CREATE SYNCHRONIZATION PROFILE statement [UltraLite], andDROP SYNCHRONIZATION PROFILE statement [UltraLite].

  • UltraLite SELECT statement   The default for UltraLite SELECT statements that do not explicitly contain a FOR clause is now FOR READ ONLY. This change allows UltraLite to choose more optimal plans for queries when updates are not permitted. See SELECT statement [UltraLite].

  • UltraLite SYNCHRONIZE statement   A new statement for synchronizing an UltraLite synchronization profile or specific synchronization options. See SYNCHRONIZE statement [UltraLite].

  • UltraLite CREATE SYNCHRONIZATION PROFILE statement   A new statement for creating an UltraLite synchronization profile. Synchronization profiles define how an UltraLite database synchronizes with the MobiLink server. See CREATE SYNCHRONIZATION PROFILE statement [UltraLite].

  • UltraLite ALTER SYNCHRONIZATION PROFILE statement   A new statement for altering an UltraLite synchronization profile. See ALTER SYNCHRONIZATION PROFILE statement [UltraLite].

  • UltraLite DROP SYNCHRONIZATION PROFILE statement   A new statement for deleting an UltraLite synchronization profile. See DROP SYNCHRONIZATION PROFILE statement [UltraLite].

  • Support for SQL Anywhere passthrough scripts   This functionality is not supported in UltraLite 12.

    UltraLite utilities now include support for SQL Anywhere pass-through scripts. The changes apply to the following utilities:

    • ulcond11
    • ulunload
    • ulload
    • ulinfo
    • ulsync


  • UltraLite database validation   You can now use the ulvalid utility or ValidateDatabase API to validate an UltraLite database. The validation tests for certain types of corruption in the database file, and you can use command line parameters to refine your results. See UltraLite Validate Database utility (ulvalid) and Validating an UltraLite database.

    UltraLite.NET now supports the ValidateDatabase function. You can now validate a database or specific tables with or without a connection. See ULDatabaseManager class [UltraLite.NET] and ULConnection class [UltraLite.NET].

    You can now use the Validate Database Wizard in Sybase Central to validate an UltraLite database. The Validate Database option is available on the Tools menu.

  • Support for events and notifications   UltraLite now supports events and notifications. Notification messages are sent to registered queues or connections when events occur. User events may also be defined and triggered by applications. APIs for events and notifications are provided in each supported language. Additionally, a SQL function is provided to access the API functionality.

  • UltraLite support for isolation levels   Now, by default, connections are isolated from each other. Uncommitted changes by other connections and downloads are not visible until committed.

    You can now set the isolation level to READ_COMMITTED or READ_UNCOMMITTED. See Change the isolation level and UltraLite transaction processing.

    UltraLite.NET now supports the ReadUncommitted isolation level. The default isolation level of a connection in auto-commit mode is ReadCommitted. See UltraLite transaction processing and Change the isolation level.

  • UltraLite ALTER DATABASE SCHEMA FROM FILE statement   You can now use the ALTER DATABASE SCHEMA FROM FILE statement to alter an UltraLite schema. The ALTER DATABASE SCHEMA FROM FILE statement replaces the 9.0.2 schema upgrade feature that was implemented with the now removed UpgradeSchemaFromFile or ApplyFile methods. Use either the ulinit or ulunload utilities to ensure that the DDL statements required are syntactically correct.


  • Extract Database Wizard behavior changes   You can now exclude tables from the extraction process, and the Extract Database Wizard now omits publications with duplicate names from the list of available publications. See Upgrading databases created with previous versions of UltraLite.

  • UltraLite client version and build number added to MobiLink log files   During synchronization, UltraLite clients now add their version and build number to the MobiLink server log. See:

  • UltraLite LOAD TABLE statement   The LOAD TABLE statement can now be executed on desktop computers. See UltraLite LOAD TABLE statement. See LOAD TABLE statement [UltraLite].

  • Background synchronization support   You can now begin a synchronization on a separate thread at any point in your application and UltraLite will upload only the rows that were committed at the time the upload began. You can now modify the database during the upload and commit your changes without affecting the upload. Any rows committed while the upload is in progress are ignored by the upload. See UltraLite concurrency.

  • Enhanced GUID identifier support   In previous versions of UltraLite, runtime allowed the input and output of UUID (Universally Unique Identifier) or GUID (Globally Unique Identifier) identifiers as either 16-byte binaries or strings. An endian conversion made the identifiers compatible with GUID structs. In UltraLite 11, GUID structs can be explicitly input and output from the runtime and the endian conversion is not required.

  • ul_stream_error struct   In UltraLite 11, the stream_id, stream_context, and error_string_length fields are removed. In addition, the error_string field has been changed from a user-supplied char * to a static char array.