cd={ ON | OFF }; ...

ContinueDownload={ ON | OFF }; ...

If dbmlsync does not receive the entire download from the server, dbmlsync does not apply any of the download data to the remote database. However, it stores the part of the download it did receive in a temporary file on the remote device, so that it can be restarted later. When you set the extended option cd=on, dbmlsync restarts the download and attempts to download the part of the previous download that it did not receive. If it is able to download the remaining data, it applies the complete download to your remote database.

If there is any new data to be uploaded when you set cd=on, the synchronization fails without restarting the download. If the download cannot be restarted, synchronization fails.

You can also restart a download with the -dc option or with the sp_hook_dbmlsync_end hook.

• Resumption of failed downloads
• sp_hook_dbmlsync_set_extended_options
• -dc dbmlsync option
• sp_hook_dbmlsync_end

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

dbmlsync -e "cd=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 cd='on';