Using Visio to Generate MySQL DDL

Question

I have a database model diagram created in MS Visio that I would like to export to a DDL file to create a MySQL database. I have already installed the MySQL ODBC driver, which I can successfully use to create a DDL file, but I still have problems.

Visio places quotation marks around table names, which are also reserved words (for example, by the user). This is not entirely true since MySQL uses backticks (`) rather than quotation marks (") for this purpose.

The MySQL ODBC driver also changes the BLOB data type to LONGVARBINARY, so it cannot be used directly with MySQL when creating the database.

Does anyone have any suggestions on how to deal with these two issues?

Answer 1

Besides editing? No.

You can use MySQL Workbench . It is very similar to visio if you create everything in design mode. In addition, with the paid version, you can create a PDF document, as well as for distribution (or transfer this PDF file to flowchart diagrams, etc. in visio), or you could create a plug-in that will generate a valid visio file output, because the workbench is fully extensible through plugins.