我正在搜索问题 从 Viso 图导出 SQL 的相反解决方案。我有用于创建 MySQL 数据库的多个表的 SQL 语句。有没有办法使用 Visio 2010 的逆向工程功能来创建其图表？
我想知道是否可以从 Visio 可以连接的 SQL 语句 (MySQL) 创建 Access 数据库...替代方案我将尝试使用另一个 MySQL 数据库，在那里创建表，然后尝试与 Visio 连接这个数据库。有任何指示如何执行此操作吗？其他方式？
I'm searching the opposite solution to the question exporting SQL from a Viso diagram. I have the SQL statement for the creation of multiple tables of a MySQL database. Is there a way to use the Reverse-Engineering feature of Visio 2010 to create a diagram thereof?
I'm wondering if it is possible to create a Access database from the SQL statement (MySQL) where Visio could connect ... Alternative I'll try to use another MySQL database, create the tables there, and try to connect with Visio to this database. Any instructions how to do this? Other ways?
发布评论
评论（1）
1）将SQL导入Access并使用Visio：
Access与MySQL语句不兼容。您必须翻译所有的陈述，并且当时只允许一项陈述。不是很方便。更多信息请访问：http://help.lockergnome。 com/office2/sql-text-file-import-Access--ftopict720045.html
如果您已完成，请使用以下说明：
http://blog.pearltechnology.com/creating-entity-relationship- diagram-in-visio/
2) 在新的 MySQL 环境中再次创建表并使用 Visio：
按照此处列出的说明进行操作http://sajjadhossain。 com/2009/02/12/reverse-engineering-mysql-database-with-microsoft-visio/comment-page-1/
问题一had：
3) 使用 MySQL Workbench：
单击数据库 -> ;逆向工程
最方便，但由于图形表示和详细程度的原因，无法在选项 2 和 3 之间做出决定。
4）使用其他软件：
http://forums.devshed.com/database-management-46/tool-to-generate-er-diagram-from-sql-code-59569.html
1) Import SQL into Access and use Visio :
Access is incompatible with MySQL statements. You would have to translate all the statements and only one statement is allowed at the time. Not very convenient. More info at: http://help.lockergnome.com/office2/sql-text-file-import-Access--ftopict720045.html
If you have finished use these instructions:
http://blog.pearltechnology.com/creating-entity-relationship-diagram-in-visio/
2) Create tables again in new MySQL environment and use Visio:
Follow the instructions listed here http://sajjadhossain.com/2009/02/12/reverse-engineering-mysql-database-with-microsoft-visio/comment-page-1/
Problems I had:
3) Use MySQL Workbench:
Click on Database -> Reverse Engineer
Most convenient but can't decide between option 2 and 3, because of graphical representation and level of detail.
4) Use other software:
http://forums.devshed.com/database-management-46/tool-to-generate-er-diagram-from-sql-code-59569.html