|
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: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 (dbisql) for UltraLite.
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 options All database creation utilities (for example, ulcreate and ulload) now support the use of extended creation options. These extended options are configured on the command line with -o, and allow you to configure the same set of database properties that you can set with Sybase Central wizards. See Extended creation-time options for details on how to use extended creation options correctly.
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 to XML 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 (ulcond10) 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. See UltraLite AppForge Registry utility (ulafreg).
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.