Forum Stats

  • 3,852,474 Users
  • 2,264,108 Discussions
  • 7,905,077 Comments

Discussions

DDL Generation/Conversion Tools

64847
64847 Member Posts: 21
edited Dec 1, 2010 4:01PM in GoldenGate
I am looking for a DDL generation tool, preferably command line, that can convert DDL of one RDBMS to another - say DDL of Oracle schema/table to MySQL/SQL Server & vice-versa. I have reviewed Oracle's SQL Developer - its DDL generation is one way MySQL to Oracle, SQL Server to Oracle etc.

I would prefer a general-purpose DDL conversion tool/utility if one exists! Also, is there a way to use GGs DDLGEN for this ? I have explored this a bit but it seems all conversions are from Tandem DDL to DDL of various RDBMS.

Thanks,

Satish

Answers

  • -joe
    -joe Member Posts: 226
    Satish,

    You can use DDLGEN to perform some basic DDL between systems but you'll likely need to make modifications to the .tpl file. Otherwise you may want to look into some other paid tools on the market.

    Good luck,
    -joe
This discussion has been closed.