| || |
logging database changes
Hi everyone. New to this forum but not new to forums completely. I tried searching with google and tried searching in this forum but haven't found what I'm looking for.
My team does testing for a restaurant point of sale system and we are constantly testing database updates. Some of them add records and some of them update existing records. What I'm looking for is a tool that can track what records are being added/changed and display the original value and the new value. This way I could check the updates a lot faster because I wouldn't have to run queries on all the different tables to see the data. It would all be right there in one place. The database is a relational PSQL database in a Fedora Linux environment.
anyone know of any tools like this?
Supervisor, SQA and deployment
Papa Johns International
order pizza online @ www.papajohns.com
Re: logging database changes
I used File Aid/CS from Compuware many moons ago, but have not had need for it in many years.
If you have a SQL database that supports extracts you could extract the data and do a diff on the output, but depending on the size that could take awhile.
Nothing learns better than experience.
"So as I struggle with this issue I am confronted with the reality that noting is perfect."
Now wasting blog space at QAForums Blogs - The Lookout