What's New in SQL Anywhere Studio
What's New in Version 8.0.2
New features in version 8.0.2
Following is a list of changes and additions to the software introduced in version 8.0.2.
Support for .NET MobiLink now supports Visual Studio .NET programming languages for writing synchronization scripts.
For more information, see Writing Synchronization Scripts in .NET, -sl dnet option, ml_add_dnet_connection_script, and ml_add_dnet_table_script.
Start classes You can now write Java and .NET code that executes at the time the MobiLink server starts the JVM or CLR, before the first synchronization.
For more information, see User-defined start classes.
Maintain unique primary keys using UUIDs A new way to maintain unique primary keys on remote databases is introduced with Universally Unique IDs (UUIDs, also known as GUIDs).
For more information, see Maintaining unique primary keys using UUIDs.
New way to handle referential integrity violations Two new client stored procedures, sp_hook_dbmlsync_download_ri_conflict and sp_hook_dbmlsync_download_log_ri_contlict, are introduced to help you manage referential integrity violations during download.
For more information, see sp_hook_dbmlsync_download_ri_violation and sp_hook_dbmlsync_download_log_ri_violation.
Simpler way to delete all rows in a remote table You can now delete all the data in a remote table by including one row in the download_delete_cursor that has NULL in every primary-key column.
For more information, see Writing download_delete_cursor scripts.
MobiLink Monitor A graphical tool, the MobiLink Monitor, has been introduced to allow you to see the time taken by every aspect of the synchronization, sorted by MobiLink user or by worker thread.
For more information, see MobiLink Monitor.
Users can estimate number of upload rows to dbmlsync A new dbmlsync command line option has been created, -urc, which allows you to improve synchronization performance by providing an estimate of the number of rows that will be uploaded.
For more information, see -urc option.
Users can specify persistent HTTP/HTTPS connections You can use the persistent option to tell MobiLink to attempt to use the same connection for all HTTP requests in a synchronization. This setting may improve performance. It should only be used when you are connecting directly to MobiLink, and not through an intermediate agent such as a proxy or redirector.
For more information, see CREATE SYNCHRONIZATION USER statement [MobiLink].
New ways to control warning messages Three new dbmlsrv9 command line options have been created: -zw, -zwd, and -zwe. With -zw, you can control which levels of warning message you want reported. With -zwd, you can disable specific warning codes. With -zwe, you can enable specific that are disabled with -zw.
For more information, see -zw option, -zwd option and -zwe option.
New verbose logging options The dbmlsync -v command line option has been altered and expanded. Now, using -v alone causes minimum verbosity. To get maximum verbosity, use -v+. There are also several new levels that can be specified to fine tune the information that is logged. These options are also available as extended options.
For more information, see -v option.
Ping support The remote database can now ping the MobiLink synchronization server.
For more information, see -pi option and Ping synchronization parameter.
New synchronization stream MobiLink now supports the HTTPS protocol. This new stream implements HTTP over SSL/TLS using RSA encryption, and is compatible with any other HTTPS server.
For more information, see -x option and CREATE SYNCHRONIZATION USER statement [MobiLink].
New buffer_size option You can now specify a maximum buffer size for a fixed length HTTP message with the buffer_size option.
For more information, see CREATE SYNCHRONIZATION USER statement [MobiLink].
Auto-dial for MobiLink clients MobiLink clients running on Pocket PC 2002 or Windows desktop computers can now connect through dial-up network connections. Using scheduling, your remote can synchronize unattended. The new synchronization stream parameters are network_name, network_connect_timeout, and network_leave_open.
For more information, see CREATE SYNCHRONIZATION USER statement [MobiLink].
Servlet Redirector MobiLink now supports Web servers that support the Java servlet API 2.2, including Apache Tomcat.
For more information, see Synchronizing Through a Web Server.
RSA cipher suite supported You can now use RSA encryption as well as the existing elliptical-curve encryption for synchronization security. The utilities gencert and readcert support the RSA certificates as well as elliptical-curve certificates.
For more information, see Transport-Layer Security.
gencert can sign pregenerated certificate requests The certificate generation utility gencert has a new command line option that allows you to sign pregenerated certificate requests.
For more information, see Certificate generation utility.