在基于Visio数据模型的Sql Server中创建数据库 [英] Create DB in Sql Server based on Visio Data Model

问题描述

我在Visio Professional（2003）中创建了一个数据库模型。我知道企业版有能力基于Visio中的数据在Sql Server中创建一个数据库。我没有安装Enterprise的选项。除了通过整个事情一个表和关系，一次从头创建整个数据库，任何人都可以推荐任何工具/实用程序/方法转换visio数据库模型为一个Sql脚本，可以用来创建一个新的DB在Sql Server？

I have created a database model in Visio Professional (2003). I know that the Enterprise version has the ability to create a DB in Sql Server based on the data in Visio. I do not have the option to install Enterprise. Aside from going through the entire thing one table and relationship at a time and creating the whole database from scratch, by hand, can anyone recommend any tool/utility/method for converting the visio database model into a Sql Script that can be used to create a new DB in Sql Server?

推荐答案

对于visio 2010有一个不错的插件Visio Forward Engineer：

For visio 2010 there is nice plugin Visio Forward Engineer:

http://forwardengineer.codeplex.com/

这篇关于在基于Visio数据模型的Sql Server中创建数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！