title: compare data in 2 SQL tables
body: <p>As part of a data regression and quality assurance exercise, I need to look for diffs between two tables that should, ideally, be nearly identical. I have looked at a large number of commercial products and can't seem to find one that satisfies all of our requirements:</p>
  
  <ul>
  <li><p>Must be able to compare LARGE tables (10 million rows, by 200 columns) very efficiently</p></li>
  <li><p>Must work across different DB servers and different DB vendors (Oracle vs. DB2)</p></li>
  <li><p>Must be able to compare tables having different structures, ignoring the columns that are not shared between the two tables</p></li>
  <li><p>Must work with a user supplied, multi-column primary key-- can't rely on key defined in DB</p></li>
  <li><p>Must run on linux/solaris. Will be run as part of a fully automated process that is executed within an enterprise environment.</p></li>
  <li><p>Must be able to run headless (wihtout GUI)</p></li>
  <li><p>Must produce formatted report that identifies row diffs (row on only one side) and value diffs</p></li>
  <li><p>Customer is willing to pay enterprise level price for right solution. In other words, price no object.</p></li>
  </ul>
  
  <p>Has anyone ever seen something like this?</p>