Project Aims

This project aims to create a simple application and framework for converting / migrating between one database format to another. This is achieved through the use of Parsers and Producers.

Parser

A parser takes a given input and turns it into structured Java objects. Anything that can be through of in some way as a database can successfully be implemented as a parser.

For example a CSV file is the equivalent of a CREATE TABLE and INSERT statements.

The following parsers are available:

• JDBC / ODBC Connection
• Tested: H2, Access, MySQL, PostgreSQL
• Any database with a JDBC driver should work (e.g: Derby, Oracle, SQLServer, etc)
• Delimited file (CSV, TAB, etc)
• Access 2000-2007 MDB (Via Jackcess)
• XML Format
• Apache Turbine
• SQL Fairy
• DB Designer
• MySQL Workbench
• Generator (Creates random schemas)

Producer

A producer takes the structured Java objects and outputs them in the correct format (CSV, XML, SQL, etc)

The following producers are available:

• SQL String (Access, MySQL, Oracle, PostgreSQL, SQL Server)
• Access 2000-2007 MDB
• Entity Relationship Diagram (DOT language)
• GraphViz, ZGRViewer
• XML Format
• Apache Turbine
• SQL Fairy
• XHTML