I am dealing with 2 tables that have identical structure. First one is the main table, and I use the second one for auditing via trigger – it just holds the current condition before auditing.
Is there a better practice to audit data changes and what is it?
My data is delicate, but on the other side – I am not planning to update it too many times.