What's New in SQL Anywhere Studio
What's New in Version 6.0.2
New features in version 6.0.2
In addition to bug fixes, Adaptive Server Anywhere version 6.0.2 includes new features in both the software and the documentation.
Cross referencesThe printed documentation is not necessarily updated with each maintenance release. Cross references in this section may not be valid in the printed documents. For current information, see the online documentation. |
UltraLite deployment option UltraLite databases for small devices such as the PalmPilot and Windows CE computers can be developed with this version of the software.
For information, see the book UltraLite Developer's Guide.
Backup and Restore SQL statements Adding BACKUP and RESTORE as SQL statements provides server side backup and automation of backups using SQL scripts.
The BACKUP statement provides direct backup to tape.
For more information, see BACKUP statement.
Security features New security features have been added.
Auditing Database administrators can keep track of activity performed on a database by turning on the AUDITING option. The record of activities is kept in the transaction log. By turning on auditing, you increase the amount of data saved in the transaction log to include login attempts, accurate timestamps of all events, all permissions checks, and all actions requiring DBA authority.
For more information, see Auditing database activity.
Minimum password length Database administrators can specify a minimum password length, to discourage easily discovered passwords.
For more information, see MIN_PASSWORD_LENGTH option [database].
Locating servers A utility is provided for troubleshooting connections.
For more information, see The Ping utility.
Starting databases from jConnect connections Database connections over TDS, including connections from Java applications over jConnect, can start a database on a server.
For more information, see Supplying a URL for the server.
getObject and setObject methods from Java client applications From Java applications, you can now retrieve objects from a table and insert objects into a table without the explicit serialization and deserialization required in previous releases.
ODBC 3.51 The ODBC driver has been updated to ODBC 3.51. This version of ODBC includes support for Unicode applications.
For more information, see ODBC conformance.
Control of allowed JOIN syntax In previous releases, some multi-table queries have been allowed that have ambiguous join clauses. In the present release, you can set an option to disallow such queries.
For more information, see EXTENDED_JOIN_SYNTAX option [database].
Administration utility enhancements Options have been added to the administration utilities to provide additional features.
Transaction Log [dbtran] utility If you use the new -d
option, dbtran puts each operation as it occurs in the transaction log file. This makes transaction log output easier to read. This has been added primarily for auditing purposes.
For more information, see Translating a transaction log using the dbtran command-line utility.
Transaction Log [dbtran] utility You can run dbtran against a running database server instead of against a log file. This feature has been added to increase the security of the transaction log—there is now no need to access the transaction log directly.
For more information, see Translating a transaction log using the dbtran command-line utility.
Log Transfer Manager [dbltm] utility logging New options allow you to tune message logging from these utilities.
For more information, see The Log Transfer Manager.
New Log Transfer Manager [dbltm] utility options New options enable you to replicate only backed up transactions (backup_only), and to shut down as soon as all data is replicated (continuous).
For more information, see The LTM configuration file.