While working on one of the MySQL to Oracle replication projects for Continuent, I needed to implement an open-source utility for transforming MySQL schema to an Oracle dialect (DDL statements that create specific schema on Oracle) to save from otherwise tedious work. This article introduces ./ddlscan tool, which does that and is extensible to do much more.
Here's what you'll need:
- Your favorite DBMS with some tables. Currently supported MySQL, Oracle and PostgreSQL.
- Latest Tungsten Replicator build. Not even needed to install, enough to untar.
- Velocity template of your