I have two tables, parent/child (1-m). I need to track all changes made to either table and maintain the relationships at the same time so I can capture an audit trail and also a snapshot at any given time a change occurred...basically to replicate what the database looked like prior to any changes made to either parent or child tables.
What would be the best way to do this? I was going to place an insert/update/delete trigger on both tables and store the old values to the history transaction tables for each table independently...but because the two tables are related, how can I recreate the snapshot which would include both tables for any given transaction change?
Start Free Trial
