I work as a tester. I found some of the defects I investigate can be traced down to differences in configuration between local and customer's environments. As the tested system has major part of configuration encoded in DB, I'm looking for a tool that would ease comparision of table data (not schemata) from two different DBs.
Particularly I would like the tool to:
- Let me configure comparision key. Let's say I have a PARAMETER table with multiple columns: ID, NAME, and VALUE. I would not like the tool to compare table entries based on primary key column (ID), but rather let me select the key column for comparision (NAME here).
- Work offline, since DBs might be in different subnetworks. For instance, I could scp the tool to the customer machine, dump selected tables to external file using the tool, scp the external file back to my local machine and then compare with my
- Visualize differences per table/column, e.g., like DiffDog does:
- Be free
If there's no such tool, I would be grateful for information on some libraries I could combine together to program a simple and naive version of it.