mysql-diff is a commandline database structure comparator. It compares the structure of two databases. It currently works with MySQL. A database can be specified as an SQL script or as an URL to a running database. So the tool can compare two scripts, two live databases, or a database and a script. The tool outputs SQL DDL script that can be used to convert one schema to another.
SpiderDB is a lightweight database schema crawler library developed using Java. It is a simple library that can be used to Crawler the underlying schema of a database and return POJO objects, which makes it very easy to use. This library takes care of all the differences among the various database management systems, and makes application code free from the DBMS differences.You keep using same POJOs even if you change the underlying DBMS.