使用Visio 2010（Professional Plus）从SQL导出实体关系图

本文介绍了使用Visio 2010（Professional Plus）从SQL导出实体关系图的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

我正在搜索相反的解决方案来解决从Viso图导出SQL的问题/ A>。我有SQL语句来创建MySQL数据库的多个表。有没有办法使用Visio 2010的Reverse-Engineering功能来创建一个图表？

我想知道是否可以从SQL语句（MySQL）Visio可以连接...另类我将尝试使用另一个MySQL数据库，在那里创建表，并尝试连接Visio到此数据库。任何说明如何做到这一点？其他方式？

解决方案

1）将SQL导入Access并使用Visio：

访问与MySQL语句不兼容。你必须翻译所有的语句，当时只允许一个语句。不是很方便。更多信息，请访问： http：//help.lockergnome。 com / office2 / sql-text-file-import-Access - ftopict720045.html

如果您已经完成使用这些说明： blog.pearltechnology/creating-entity-relationship-diagram -in-visio /

2）在新的MySQL环境中再次创建表，并使用Visio：

按照此处列出的说明我遇到的问题：

• 得到错误主机不允许连接到这个MySQL服务器。使用phpmyadmin并转到权限，在那里您更改用户的主机（例如到％）
• 在上述说明中，我在步骤12中使用了ODBC通用驱动程序（ maniish.wordpress/2007/11 / 24 / reverse-engineer-mysql-in-visio-2007 / ）

3）使用MySQL Workbench： / p>

点击数据库 - >逆向工程师

最方便但不能在选项2和3之间决定，因为图形表示和细节水平。

4）使用其他软件：

forums.devshed /database-management-46/tool-to-generate-er-diagram-from-sql-code-59569.html

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) 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: help.lockergnome/office2/sql-text-file-import-Access--ftopict720045.html

If you have finished use these instructions: blog.pearltechnology/creating-entity-relationship-diagram-in-visio/

2) Create tables again in new MySQL environment and use Visio:

Follow the instructions listed here sajjadhossain/2009/02/12/reverse-engineering-mysql-database-with-microsoft-visio/comment-page-1/

Problems I had:

• Got the error "Host is not allowed to connect to this MySQL server". Use phpmyadmin and go to rights, where you change the host of your user (e.g. to %)
• In the instructions above I used in step 12 the "ODBC Generic driver" ( maniish.wordpress/2007/11/24/reverse-engineer-mysql-in-visio-2007/)

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:

forums.devshed/database-management-46/tool-to-generate-er-diagram-from-sql-code-59569.html