使用Visio生成MySQL DDL [英] Using Visio to generate MySQL DDL

问题描述

我有一个在MS Visio中创建的数据库模型图，我想将其导出到DDL文件以创建一个MySQL数据库.我已经安装了MySQL ODBC驱动程序，可以成功使用该驱动程序生成DDL文件，但是无论如何我还是有一些问题.

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

Visio在表名两边加上引号，这些表名也是保留字(例如用户).这不行，因为MySQL为此使用了反引号(`)而不是引号().

Visio puts quotation marks around the table names which are also reserved words (like user). This is not OK, since MySQL uses backticks (`) and not quotation marks (") for this purpose.

MySQL ODBC驱动程序还将BLOB数据类型更改为LONGVARBINARY，因此在创建数据库时不能直接与MySQL一起使用.

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 suggestion how to deal with these two problems?

推荐答案

除了编辑以外?不.

您可以考虑使用 MySQL Workbench .如果您在设计模式下创建所有内容，则它与visio非常相似.此外，使用付费版本，您还可以生成一个pdf文档进行分发(或将该PDF放入visio中的流程图中，等等)，或者您可以创建一个插件，该插件可以在输出中生成有效的visio文件，因为workbench是通过插件完全可扩展.

You might consider using MySQL Workbench. It is very similar to visio if you create everything in design mode. Additionally, with the paid version you can generate a pdf document as well for distribution (or plop that PDF into the flow chart diagrams, etc in visio) or you could possibly create a plugin that would generate a valid visio file on output since workbench is fully extensible via plugins.

这篇关于使用Visio生成MySQL DDL的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！