Is it possible to export a database model from visio to Sql Server 2005?

Hi there,

I cannot seem to find a way to export a database model from Visio to Sql Server.

Can somebody provide a walkthrough how to export it?

Thanks a lot

Not sure if this is what you mean but you can't export the data model from Visio into SQL Server database diagrams.

-Sue

|||

What I mean is .

I use Visio to write technical specs. I have lots of them with data Model in them.When it comes to write the functionality I would like to generate the tables into SqlServer and avoid to rewrite them from scratch.

Is this possible?

|||

Yes you can. I have done this with Visio 2003 for Enterprise Architects (I think that's the edition at least), it has the ability to generate a sql script of your visio data model. I did not see this functionality in any other edition of visio 2003 (had professional before). Not sure about visio 2007.

Here's a link to how to do it in Visio 2003:

http://www.codeproject.com/gen/design/visioDatabase.asp?df=100&forumid=372789&exp=0&select=1840912

|||

Same for Visio 2007, you need the EA functionality in order to do this.

Jens K. Suessmeyer

http://www.sqlserver2005.de