[4 total ]
SchemaSpy is a Java-based tool that analyzes the metadata of a schema in a database and generates a visual representation of it in a browser-displayable format.
It lets you click through the hierarchy of database tables via child and parent table
... [More]
relationships.
The browsing through relationships can occur though HTML links and/or though the graphical representation of the relationships.
It's also designed to help resolve the obtuse errors that a database sometimes gives related to failures due to constraints. [Less]
LiquiBase is a DBMS-independent library for tracking, managing and applying database changes. It is built on a simple premise: All database changes (structure and data) are stored in an XML-based descriptive manner and checked into source control.
... [More]
LiquiBase aims to provide a solution that:
* Supports merging of changes from multiple developers
* Works well with code branches
* Allows you to manage production data as well as various test datasets
* Works in an environment where multiple machines will be attempting to migrate the database concurrently
* Supports automated change-applying or generation of SQL scripts that can be approved and applied by a DBA
* Supports rolling back changes
* Database "diff" tool [Less]
Model-based data export tool. Exports consistent, referentially intact row-sets from relational databases. Removes obsolete data without violating integrity. DBMS agnostic (JDBC). Generates hierarchically structured XML and topologically sorted SQL-DML.
dub manages databasemodifications (schema-evolution) during the development process/maintenance. It centralizes the changes, in order to execute them to the target database, and will keep an overview of all exising changes (new, current and past).