|
The following options are included to provide control over SQL Remote replication behavior.
| Option | Values | Default |
|---|---|---|
| blob_threshold option [SQL Remote] | Integer (in kilobytes) | 256 |
| compression option [SQL Remote] | Integer, from -1 to 9 | 6 |
| delete_old_logs option [MobiLink client] [SQL Remote] [Replication Agent] | 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-sting | YYYY/MM/DD HH:NN:SS.SSSSSS |
| 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 |