我在Microsoft Visio中有一个数据库图表如何将其导入Sql Server 2005？

I have done a database diagram in Microsoft Visio but I don't know how to import it to Sql Server 2005?

我在Microsoft Visio中做了一个数据库图,但我不知道如何将它导入Sql Server 2005?

By the way, which is the best tool you think you can use to do database diagrams, and that allows you to import it to Sql Server?

顺便说一句,哪个是您认为可以用来做数据库图表的最佳工具,并且允许您将其导入Sql Server?

2 个解决方案

#1

类似的主题在这里:http://www.linkedin.com/answers/technology/software-development/TCH_SFT/291114-19420164?browseCategory=TCH_SFT

Reproduced here:

So long as you have the Enterprise Architecture version of Visio, all you have to do is click: Database -> Generate.

只要您拥有Visio的企业架构版本,您只需单击:数据库 - >生成即可。

From there you can generate the DDL and even create a new database.

从那里你可以生成DDL甚至创建一个新的数据库。

Once you have the DDL you will have to use a query window to open the file and then so long as you have access to create a new schema and tables, etc... you can create your new database.

获得DDL后,您将不得不使用查询窗口打开文件,然后只要您有权创建新的模式和表等,就可以创建新的数据库。

In my openion Microsoft Visio is the best which works with Microsoft SQL Server.

在我的公开场合,Microsoft Visio是最适合Microsoft SQL Server的。

#2

i'm not 100% sure you can import database diagrams from vision into sql server 2005

我不是100%确定你可以将数据库图表从愿景导入到sql server 2005中

sql server 2005 has a neat built-in database diagram tool that actually builds the tables and relationships as you build them in the diagram.

sql server 2005有一个简洁的内置数据库图表工具,可以在图表中构建表格和关系时实际构建表格和关系。

#1