Forum Discussion
SSMS Help - Capturing Changes in the data and recording
threw000 Hi if I understand
1) I would recommand to use change data capture feature on base table with data in case you work with sql server standard/enterprise/developer edition as described here - https://janzednicek.cz/en/sql-server-change-data-capture-cdc-tracking-changes-in-a-table/
2) in case you use express edition, then recommandation nr 2 is a trigger as someone here stated also on base table - https://janzednicek.cz/en/sql-triggers-in-sql-server-definition-types-syntax-and-examples/
3) in case you cant do any of above just craft ssis package doing snapshot of base table (full load) and save this snapshot into temporary table. After that identify increment by usint except command and insert it into destination table. hope it helps