How can I keep target in sync with source whose records are replaced monthly?

Using Replication to copy CRM data to Azure SQL DB. One CRM table's data is replaced (not updated) monthly (has new CreatedOn/ModifiedOn dates), but older versions are still in the target table, not deleted when the solution runs.

(1) Answer

Login