Projects

SQuirreL SQL Client

SQuirreL SQL Client is a graphical SQL client written in Java that will allow you to view the structure of a JDBC compliant database, browse the data in tables, issue SQL commands etc.

LiquiBase

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. LiquiBase aims to provide a solution that: * ... [More] 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

SchemaSpy analyzes database metadata to reverse engineer dynamic Entity Relationship (ER) diagrams. It works with just about any JDBC-compliant database (Oracle/MySQL/DB2/SQL Server/PostgreSQL/Sybase/etc.) and can identify Ruby on Rails as well as other implied relationships.

jOOQ

jOOQ effectively combines complex SQL, typesafety, source code generation, active records, stored procedures, advanced data types, and Java in a fluent, intuitive DSL.

Eclipse SQL Explorer

Eclipse SQL Explorer is a thin SQL client that allows you to query and browse any JDBC compliant database. It supports plugins with specialized functionality for individual databases (Oracle, DB2 and MySQL) and can be extended to include specialized support for other databases. The project ... [More] started as a fork from the original JFaceDb project which has gone commercial and uses some of the core libraries of SQuirreL SQL. [Less]

dbclient

Simple yet Powerful Jdbc Tool for browsing Relational databases. DBClient provides both a convenient SQL Editor (highlighting, auto-complete, ...) and automated Browsing and Refactoring Actions (Select, Drop, etc...). Since release 0.3, it is massively based on Plugins architecture which makes it very extensible.

SchemaCrawler

SchemaCrawler is an open-source Java API that makes working with database metadata as easy as working with plain old Java objects. SchemaCrawler is also a database schema discovery and comprehension, and schema documentation tool. You can search for database schema objects using regular ... [More] expressions, and output the schema and data in a readable text format, and find potential design issues with lint . The output is designed to be diff-ed against other database schemas. SchemaCrawler supports almost any database that has a JDBC driver, but for convenience is bundled with drivers for some commonly used RDBMS systems. SchemaCrawler works with any operating system that supports Java. [Less]

SolidBase

SolidBase is a database change and version control tool using annotated SQL. Strengths & Features - Database changes are written in SQL; - Keeps developer, test AND production databases identical; - Existing data can be maintained and/or transformed as needed; - Real version control ... [More] , not a bunch of changes; - Version information is kept in the database itself; - Multiple upgrade paths can be defined to support the code branching strategies used during system development. Switching from one path to the other is also supported; - Database vendor agnostic, only JDBC connections needed; - Supports controlling multiple databases and/or schemas with one version number; - Ant task and Maven plugin available, as well as a commandline version that is optionally backed by a properties file. [Less]

Dub

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).

vpu

FAnAD - Ferramentas Analíticas para Administração de Dados Sabemos que as equipes de administração de dados além de administrarem acesso e regras sobre os bancos. VPU - Verificação de Permissões entre Usuários.