SQL Remote options

The following options provide control over SQL Remote replication behavior.

Option Values Default
blob_threshold option [SQL Remote] Integer (in bytes) 256
compression option [SQL Remote] Integer, from -1 to 9 6
delete_old_logs option [SQL Remote] On, Off, Delay, n days Off
external_remote_options [SQL Remote] On, Off Off
qualify_owners option [SQL Remote] On, Off On
quote_all_identifiers option [SQL Remote] On, Off Off
replication_error option [SQL Remote] Stored procedure name (no procedure)
replication_error_piece option [SQL Remote] Stored procedure name (no procedure)
save_remote_passwords option [SQL Remote] On, Off On
sr_date_format option [SQL Remote] date-string yyyy/mm/dd
sr_time_format option [SQL Remote] time-string hh:nn:ss.Ssssss
sr_timestamp_format [SQL Remote] timestamp-string yyyy/mm/dd hh:nn:ss.Ssssss
sr_timestamp_with_time_zone_format [SQL Remote] timestamp-with-time-zone-string yyyy/mm/dd hh:nn:ss.Ssssss +hh:nn
subscribe_by_remote option [SQL Remote] On, Off On
verify_all_columns option [SQL Remote] On, Off Off
verify_threshold option [SQL Remote] Integer (in bytes) 1000