sqlddlerddraw.io

Use Draw.io to generate SQL / DDL scripts?


There are a lot of resources on internet about how to import tables into ER diagram on Draw.io using sql script.

For example here (but I find plenty of resources googling):

https://www.drawio.com/doc/faq/sql-plugin (SEE PARAGRAPH "Create an ER diagram from SQL code")

I cannot find anything in the reversed direction. Is it possible to create DDL scripts from a ER diagram created through Draw.io?

(plugin? export as xml and import in other tools? anything else...)

I'm dealing with a ER diagram provided by suppliers in Draw.io format. I would like to avoid to handwrite all DDL... (my case is Oracle 12)


Solution

  • Reviewing this my old post I'd like to update that I did not find anything.

    So the answer is NO. It's not possible to create DDL from design using Draw.IO

    Suppliers were told to begin to learn and work free SQL Data Modeler inside Oracle Sql Developer. It's perfect because diagrams generated with this tool can be used to compare diagram generate from db, creating differences and incremental scripts.