Have Geek Brain

I have a database diagram in Microsoft Visio, how can I import it to Sql Server 2005?

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

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

+1


a source to share


2 answers


A similar topic here: http://www.linkedin.com/answers/technology/software-development/TCH_SFT/291114-19420164?browseCategory=TCH_SFT

Reproduced here:



As long as you have the Enterprise Architecture version of Visio, all you need to do is click: Database → Generate.

     

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

     

Once you have the DDL, you will need to use a query box to open the file, and then, while you have access to create a new schema and tables, etc., you can create your new database.

In my opening, Microsoft Visio works best with Microsoft SQL Server.

+2


a source


I'm not 100% sure you can import database diagrams from vision in SQL Server 2005



sql server 2005 has a neat built-in database diagram tool that actually creates tables and relationships when you create them in a diagram.

0


a source






More articles:


All Articles