Eric Lehti
VIP Member
Hi Luke, You posted a response to my DBAM question, and I am starting this new thread "DBAM triggers versus Journaling for auditing"
You said, "How do you find DBAM? Most companies are using journaling these days rather than triggers."
Please expand on your point.
Can DBAM triggers function similar to Journaling?
We use Journaling (the Vision Solutions iTera Echo2 High-availability product) also. A journal entry is created for every change anywhere in an object (Add/change/delete), and transmits the journal entry to the Target HA machine so that the HA machine is a mirror of production. The Journal Receivers expire and get deleted after 48 hours so that disk space is conserved.
We use DBAM to perform a field-level granular audit of one or several fields in a physical file, not every field in a table. The before-and-after state of the field(s) is written to a physical file.
Are you saying that journaling is typically used in the fashion I describe for DBAM? What commercial solutions use journaling for auditing database changes at the field/column level? My understanding is that journaling tracks changes on all columns in a table.
I do not understand how journaling can provide the functionality that we enjoy with DBAM triggers.
You said, "How do you find DBAM? Most companies are using journaling these days rather than triggers."
Please expand on your point.
Can DBAM triggers function similar to Journaling?
We use Journaling (the Vision Solutions iTera Echo2 High-availability product) also. A journal entry is created for every change anywhere in an object (Add/change/delete), and transmits the journal entry to the Target HA machine so that the HA machine is a mirror of production. The Journal Receivers expire and get deleted after 48 hours so that disk space is conserved.
We use DBAM to perform a field-level granular audit of one or several fields in a physical file, not every field in a table. The before-and-after state of the field(s) is written to a physical file.
Are you saying that journaling is typically used in the fashion I describe for DBAM? What commercial solutions use journaling for auditing database changes at the field/column level? My understanding is that journaling tracks changes on all columns in a table.
I do not understand how journaling can provide the functionality that we enjoy with DBAM triggers.