Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 17 » SQL Anywhere - Changes and Upgrading

What's new in SQL Remote version 17.0

SQL Remote version 17.0 includes enhancements and behavior changes.

Deprecated features will be removed in future versions. Alter your applications to use recommended feature replacements instead of relying on deprecated features.

Note

Check the readme.txt file for additional information about the software, including feature information that was added after the documentation was completed.

Enhancements
  • Enhancements to dbremote offline transaction log retrieval

    The dbremote utility now retrieves offline transaction logs from the SQL Anywhere database server instead of accessing them directly. If offline transaction logs are required but the given offline transaction log directory cannot be opened or it does not contain offline transaction log files, then dbremote retrieves the offline transaction logs through the database server. The following restrictions apply:

    • The user ID that is used by dbremote to connect to the replication database must have the READ FILE and WRITE FILE privileges and all the offline transaction log files must be in the online transaction log directory.

    There is a slight performance penalty when using this feature because the database server performs extra work to retrieve the transaction logs.

    See SQL Remote Message Agent utility (dbremote).

Behavior changes
  • Changes to the SQL Remote Extract utility (dbxtract) and Extract Database Wizard

    Previously, when extracting a database using the Extract utility (dbxtract) or the Extract Database Wizard in SQL Central, passwords were unloaded by default. Now, they are not. You must now specify whether to extract passwords (-up option in dbxtract, and a new UI control in the Extract Database Wizard), and you must have the ACCESS USER PASSWORD system privilege to extract them. See Extraction utility (dbxtract).