Projects tagged ‘development’, ‘jdbc’, and ‘mysql’

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]

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]

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.