Note for bounty: please answer only if you know a tool that can monitor what changes in the same db, don't mention tools that compare 2 dbs. A visual tool, like Embarcadero Change Manager is appreciated.
I'd like to have a tool that allows me to see only "what changed" in a db, given a specific action.
Scenario can be:
1) start monitoring (with the tool)
2) user performs an action on GUI (like clicking the button "apply" after having changed the telephone number of a customer)
3) stop moniroting: show changes (with the tool) (in this case I should only see that the Address field has been changed)
Embarcadero's Change manager does this, but it does also many other things, and it is expensive. I am looking for a simpler tool that does only this.
Note: I don't need schema comparison, just simple data comparison.
You can make Database Snapshots (quickly enough) and then compare with working DB. Both issues can be solved with free tools.