Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » MobiLink - Server Administration » Synchronization Techniques » Handling deletes

Handling deletes Next Page

Temporarily stopping the synchronization of deletes

Ordinarily, SQL Anywhere automatically logs any changes to tables or columns that are part of a publication with a synchronization subscription. These changes are uploaded to the consolidated database during the next synchronization.

You may, however, want to delete rows from synchronized data and not have those changes uploaded. You can do this using STOP SYNCHRONIZATION DELETE. This feature can be used to make unusual corrections, but should be used with caution as it effectively disables part of the automatic synchronization functionality. This technique is a practical alternative to deleting the necessary rows using a download_delete_cursor script

When a STOP SYNCHRONIZATION DELETE statement is executed, none of the delete operations subsequently executed on that connection are synchronized. The effect continues until a START SYNCHRONIZATION DELETE statement is executed. The effects do not nest; that is, subsequent executions of STOP SYNCHRONIZATION DELETE after the first will have no additional effect.

To temporarily disable upload of deletes made through a connection
  1. Issue the following statement to stop automatic logging of deletes.

  2. Delete rows from the synchronized data, as required, using the DELETE statement. Commit these changes.

  3. Restart logging of deletes using the following statement.


The deleted rows will not be sent up to the MobiLink server and hence will not be deleted from the consolidated database.

See also