If you are using a download subset to synchronize a subset of the data on the consolidated database, then by default the download delete subset is set to Same, which makes it exactly the same as the download subset. You can choose to change it to None or Custom. If the download subset is Custom and you are using a shadow table to track deletes, you need to ensure the shadow table has the required columns and that the expression does not explicitly reference the consolidated table. Open the Download Delete Subset tab in the lower pane to add any non-primary key columns used in your custom download subset SQL expression to the shadow table.

You can set up a custom download delete subset in the same way as a custom download subset, except that you can also choose extra columns for the shadow table if you are using a shadow table to track deletes.

 See also