7
We do have the option to export "FULL LOAD" to an external database.
This will truncate the data, and re-insert a new version of all rows.
For large tables, this will move A LOT of rows each day.

We also have the option to export incrementally. This needs change tracking.
This will read change tracking, and merge the results into the database.
For large tables, change tracking is simply not feasible. Too slow.

I would like to be able to export all "Changed in the last X days",
then have the export merge this with existing data in the database,
without truncating.

I know this will not support deletes. That's fine.
Category: Data Management
STATUS DETAILS
Needs Votes