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

SAP Sybase SQL Anywhere 16.0 » MobiLink - Getting Started » MobiLink technology » MobiLink plug-in for Sybase Central » Synchronization models » Synchronization model tasks

 

Modifying how deletes are recorded

Use the Download Deletes tab to control whether deletions on the consolidated database are downloaded to remotes, and how the information about those deletes is stored in the consolidated database.

Prerequisites

You must have a synchronization model and the download type for the table mapping must be set to Timestamp.

Context and remarks

If you are using snapshot download, all rows in the remote database are deleted before the snapshot is downloaded so there is no need to track delete operations. If you are using timestamp-based download, you can decide how you want deletes on the consolidated database to be recorded for downloading to the remote database.

To delete rows from remote databases when they are deleted from the consolidated database, you must keep a record of each deleted row. You can record this information with shadow tables or by using logical deletes.

 Task
  1. Double-click the MobiLink project name.

  2. Double-click Synchronization Models and then select your synchronization model name.

  3. Click the Mappings tab.

  4. In the Table Mappings pane, select a table mapping.

  5. In the Details pane, open the Download Deletes tab.

  6. Select the Download Deletes checkbox to download deletes from the consolidated database. Clear the checkbox if you do not want to download deletes from the consolidated database.

    To record deletions, you can choose to use a shadow table or logical deletes.

Results

The method of handling deletes is updated.

 Logical deletes
 See also