dbdiff

dbdiff is a command-line perl utility that provides diff'ing functionality for databases supported by the perl DBI. It currently provides schema differencing for tables and views as text output, future versions seek to provide sql generation to bring a database's schema into sync with another database, and eventually will provide the ability to diff the data as well. Development is being done against Postgres 8.x at this time, however plans are to support MySQL and perhaps Oracle, if the mood strikes and the DBI provides access to it, I might even take the time to bring up support for SQL Server.

• 10.20.2005 : version 0.0.1 released :
  This is the first development release of dbdiff, it is not terribly functional, nor even usable, at this point, however I wanted to get into the habit of releasing this utility early in its development. At this point there is just a configuration file devdb.conf that specifies
  
  

• Mac OSX v10.4.2/PostgreSQL
• FreeBSD v5.4/MySQL