Data Research Group has made use of many open source solutions in the past, in return we have made a few contributions of our own. Among these is DBReconcile.

DBReconcile is a set of utilities to scan metadata from a JDBC and SQL-compatible database and replicate the database structure and specified content in a different installation. This utility is intended to help distribute new versions of software products which use databases; new releases may require new tables or new columns in existing tables. If the database stores fixed information such as security clearance levels or salutations such as "Mr." or "Mrs." such data must also be updated in the customer's database as part of a software upgrade. Our reconciliation utility examines the master database and writes a structure file which describes all the tables in the database and a content file which includes any data which is part of the upgrade. These files become part of the software distribution. Our installation script compares the customer's database content and structure with these files, updating the database as needed.

You can find the SourceForge listing here, or you can download the files from our Resource Center.