Administration tools

Administration tools have been enhanced with this release. To ensure the correct usage of a tool, ensure you review the documentation for it.

Graphical administration tools
  • Sybase Central   You can now use Sybase Central to create, modify, and administer your UltraLite databases in a graphical user interface. This replaces the ulview schema editing utility.

    The list of wizards included in Sybase Central include:

    • Use the Create Database wizard to build a new UltraLite database. This wizard shares the same functionality as the ulcreate utility.
    • Use the Erase Database wizard to erase an existing UltraLite database. No utility equivalent exists for this wizard.
    • Use the Extract Database wizard to initialize a new UltraLite database from a SQL Anywhere reference database. This wizard shares the same functionality as the ulinit utility.
    • Use the Load Database wizard to load an XML file into an UltraLite database. This wizard shares the same functionality as the ulload utility.
    • Use the Migrate C++ API wizard to migrate C/C++ code created with the removed ulgen utility. No utility equivalent exists for this wizard.
    • Use the Synchronize Database wizard to synchronize an UltraLite database. This wizard shares the same functionality as the ulsync utility.
    • Use the Upgrade Database wizard to upgrade an existing UltraLite database from a previous version. This wizard shares the same functionality as the ulunloadold utility when used with the ulload utility.
    • Use the Unload Database to unload data/schema information from an UltraLite database to XML, SQL, or another database. This wizard shares the same functionality as the ulunload utility with the additional functionality of the ulcreate and ulload utilities.

  • Interactive SQL   You can now use Interactive SQL to develop and test SQL statements with UltraLite databases. Interactive SQL replaces the ulisql utility used in previous versions. See Interactive SQL utility for UltraLite (dbisql).

Command line administration tools

The following command line utilities are new to UltraLite:

  • Unload Old Database utility   The new ulunloadold command line utility helps you to unload existing 8.0.2 or 9.x UltraLite databases (schema + data) or schema files to an XML file. With the ulload command line utility, you can then use that output to rebuild an UltraLite version 10 database. See UltraLite Unload Old Database utility (ulunloadold).

  • Information utility   The new ulinfo utility displays information about an UltraLite database. It can also change and/or clear database option IDs like global_id or ml_remote_id. See UltraLite Information utility (ulinfo).

Also, because existing command line utilities have been enhanced to support the new RDBMS features in UltraLite 10, the options for these utilities have changed from earlier versions. To ensure you are using new utilities correctly, ensure you review the reference documentation before starting. See UltraLite utilities reference for complete utility reference notes.

  • Enhanced error reporting   UltraLite utilities now report errors consistently with other SQL Anywhere utilities.

  • Extended database creation parameters   All database creation utilities (for example, ulcreate and ulload) now support the use of extended creation parameters. These extended creation parameters are configured on the command line with -o, and allow you to configure the same set of features that you can configure with Sybase Central wizards. See Choosing database creation parameters for UltraLite.

  • Enhanced unload behavior   You can now use ulunload to output the UltraLite database schema as a sequence of dynamic SQL statements. See UltraLite Unload Database utility (ulunload).

  • Enhanced ulsync behavior   ulsync allows you to set network protocol options and extended synchronization parameters directly from this utility. See UltraLite synchronization parameters and network protocol options for a complete list.

    Additionally, ulsync now allows you to name publications, not just the publication mask. The keyword Publications takes a comma separated list of publication names. See UltraLite Synchronization utility (ulsync) for details.

  • Enhanced conduit installation   The HotSync Conduit Installation utility (ulcond10) now supports conduit extensions, connection strings, and multiple databases. See UltraLite HotSync Conduit Installation utility for Palm OS (ulcond11) for details.

  • ulmvbreg   The ulmvbreg utility that registers UltraLite for AppForge has been renamed to ulafreg. This utility is now installed to the install-dir\win32 directory.

ULSQLCONNECT

Previously, all UltraLite utilities received connection information from the command line. Now, if you want to pass information other than default user IDs and passwords, you can set the ULSQLCONNECT environment variable on your host machine. See Storing UltraLite parameters with the ULSQLCONNECT environment variable.