If you had a chance to play around with ClearDB Documenter
, you should have noticed that along with producing database reports, it can also run comparisons
. What does it compare? Technically, it compares two database reports that you previously generated. In fact, it compares two databases or two states of one database. In a rapidly developing system, especially with a multi user access, it's hard to track all the changes being made. By regularly running comparison, you can trace data movements and alterations, check the results of another code review session, or make sure new code has not brought about any security issues. Or you simply need to know how the Database A differs from the Database B, and that's it.