Data Replication with SQL Remote

Home

Data Replication with SQL Remote

Part 1 Introduction to SQL Remote

Chapter 1: Welcome to SQL Remote

New features in version 6.0.3

In addition to bug fixes, SQL Remote version 6.0.3 includes the following new features. Features in Adaptive Server Anywhere that are particularly relevant to SQL Remote are also included in this list:

FTP and SMTP/POP support on UNIX
The range of message systems supported on UNIX operating systems has been expanded to include FTP and SMTP/POP.
For a listing of supported operating and message systems, see Supported Platforms and Message Links .
Message link options stored in the database
The message link parameters that control SQL Remote behavior over each message system can now be stored in the database as opposed to the registry. This simplifies deployment and management issues related to message link parameters.
For more information, see Setting message type control parameters , SET REMOTE OPTION statement , and sp_link_option procedure .
Date and time replication formats
You can now specify database options that instruct SQL Remote what format to use when replicating dates and times. These options are SR_time_format, SR_date_format, and SR_timestamp_format.
For more information, see Replication of dates and times , and SQL Remote options .
Message Agent and SQL Remote Open Server run as a daemon
On UNIX operating systems you can run these applications as a daemon using the -ud command-line option.
For more information, see The Message Agent , and The SQL Remote Open Server .
Easier unload and reload of Adaptive Server Anywhere databases
The dbunload utility has been enhanced (
```
-ar
```
command-line option) to allow a single-step unload and reload of a database that can be used whether or not your database is involved in replication.
For more information, see Unload utility options , and Unloading and reloading a database .
Enhanced dblog output
The dblog utility now displays additional summary information, including offset information.
For more information, see The DBLOG command-line utility .
dbtran utility enhancements
The dbtran command-line utility permits filtering of the transaction log operations to isolate subsets of operations. This is of particular use to SQL Remote administrators.
For more information, see The DBTRAN command-line utility .

Behavior changes

The following behavior has changed in version 6.0.3:

Message link parameters stored in the database
By default, the message link parameters are now moved into the database when the Message Agent is run for the first time with the new version of the software. If you have software that explicitly accesses these parameters in their old locations external to the database, it will be affected by this change. You can continue using the old behavior by setting the External_remote_options database option to ON.
Passwords stored
When a password is entered for a message link, it was not stored in previous versions of the software. As the parameters are now held in the database, a saved password is not held on disk and so is more secure. Passwords are now saved by default. You can continue using the old behavior by setting the Save_remote_passwords option to OFF.

Upgrade issues

You can use the version 6.0.3 software with your existing databases.

You must upgrade Adaptive Server Anywhere databases to version 6.0.3 of the software if you wish to take advantage of storing of message link parameters in the database, or if you wish to use the datetime replication options. You must upgrade the SQL Remote tables in your Adaptive Server Enterprise database to be able to use these features.

For information on upgrading Adaptive Server Anywhere databases, see ALTER DATABASE statement , or The Upgrade utility .

For information on upgrading Adaptive Server Enterprise databases, see Upgrading SQL Remote for Adaptive Server Enterprise .


	Expand Search