Administration tools have been enhanced with this release. To ensure the correct usage of a tool, ensure you review the documentation for it.
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:
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).
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.
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.
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.
|Send feedback about this page via email or DocCommentXchange||Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0|