Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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:

  1. 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).
  2. 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
  3. Visualize differences per table/column, e.g., like DiffDog does: enter image description here
  4. 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.

share|improve this question

closed as off-topic by Max Vernon, Phil, Mike Walsh, Mark Storey-Smith, RolandoMySQLDBA Nov 21 '13 at 2:48

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Shopping list question - questions about which tool, library, product or resource you should use are off-topic here because they quickly become obsolete and often are just about the preferences of the answerer. If you have an issue with or a question about a specific tool, please revise your question to conform to that scope." – Max Vernon, Phil, Mike Walsh, Mark Storey-Smith, RolandoMySQLDBA
If this question can be reworded to fit the rules in the help center, please edit the question.

You can take a look on… . However, it's quite subjective what tool is the best. – a1ex07 Nov 20 '13 at 20:07
@a1ex07, thanks. Looks good, but it's not free. Probably because it's Oracle and probably because it does much more than I need. – dzieciou Nov 20 '13 at 20:18
Compared to Oracle license it's practically free :) I doubt 'free' is applicable to anything useful for Oracle. – a1ex07 Nov 20 '13 at 20:28
Well, I could dump content of a selected table using bash, maybe to some format, use another tool or programming library to compare output and and yet another to visualize this difference and bind all this together in bash, java, python, perl or whatever language. Was wondering if someone else did this before. That would be for free. – dzieciou Nov 20 '13 at 20:46
Well, I do not agree this is purely shopping list question, because of the last sentence in the question: I asked about possibility to program a possible solution if a tool is not an option. I was able to resolve the problem by combining PL/SQL and SQL*Loader (exporting/importing data) and Java Velocity library (for generating reports). – dzieciou Dec 30 '13 at 20:07

Browse other questions tagged or ask your own question.