Hi Guys,
I have a database and I need to generate a report every month. Is it a good practice to copy the transaction tables to a new table just for reporting purposes and audit trail. And also for the purpose of viewing the prior year reports.
Printable View
Hi Guys,
I have a database and I need to generate a report every month. Is it a good practice to copy the transaction tables to a new table just for reporting purposes and audit trail. And also for the purpose of viewing the prior year reports.
I'm going to go out on a limb here because I am not going to suggest I am an expert or anything but doesn't that go against the normalization rules of database design? I assume you are referring to holding this information for long term not temporarily.
Better to design the database to prevent the capabilities of editing previous records and forcing reversal entries of originals if necessary in order to edit them for audit trail purposes.