A Java application to convert / migrate from one database dialect to another.
How it works: Parser -> Java objects representing query -> Producer
Project Aims
This project aims to create a simple framework for converting from one SQL dialect to another. When a parser is implemented it will be able to output automatically to any of the available producers.
Parser
A parser can be any of the following:
- 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 MDB (Via Jackcess)
- XML Format
Producer
A producer can output any of the following:
- SQL String (Access, MySQL, PostgreSQL, SQL Server)
- Access 2000 MDB
- Entity Relationship Diagram (DOT language)
- XML Format
- Apache Turbine
- SQL Fairy
- XHTML
Current Development
- Rewriting XML Parser interface to use XPath
- GUI Interface
