Specifies that the values of rows that are uploaded and downloaded should be logged.

Syntax

vr={ ON | OFF }; ...

Remarks

This option is identical to dbmlsync -vr. If you specify both -v and the extended options and there are conflicts, the -v option overrides the extended option. If there is no conflict, the verbosity logging options are additive—all options that you specify are used. When logging verbosity is set by extended option, the logging does not take effect immediately, so startup information is not logged. By the time of the first synchronization, the logging behavior is identical between the -v options and the extended options.

For more information, see -v option.

The default is OFF.

This option has a short form and long form: you can use vr or VerboseRowValues.

You can also store extended options in the database. For more information about dbmlsync extended options, see Introduction to dbmlsync extended options.

See also

• Verbose (v) extended option
• Verbose (v) extended option
• VerboseMin (vm) extended option
• VerboseOptions (vo) extended option
• VerboseRowCounts (vn) extended option
• VerboseUpload (vu) extended option

Example

The following dbmlsync command line illustrates how you can set this option when you start dbmlsync:

dbmlsync -e "vr=on"

The following SQL statement illustrates how you can store this option in the database:

CREATE SYNCHRONIZATION SUBSCRIPTION
   TO sales_publication
   FOR ml_user1
   OPTION vr='on';