Creating a DB from our Visio ERD

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

Database Design and Application Architecture

Creating a DB from our Visio ERD

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2007-01-19 : 10:52:05

Marcelo writes "Good morning. In my own defense (jaja), I have read the FAQ and the Database Design sections and I did not find anything. I have also searched the Web, but no luck.

We have an ERD in Visio that we need to move to SQL Server 2005. Ideally what we would like is to be able to create all the objects from our ERD in Visio. How can I do this?

Thanks in advance, Marcelo."

AndrewMurphy
Master Smack Fu Yak Hacker

2916 Posts

Posted - 2007-01-19 : 11:45:19

There are some here with experience in reversing SQL Diagrams into Visio ERD pictures. Maybe search and target those who have used this to see if they have done what you are trying to do.

X002548
Not Just a Number

15586 Posts

Posted - 2007-01-19 : 12:26:28

or use the help in Visio?

Depending on what version you have, It may not have 2k5

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam

meareal
Starting Member

21 Posts

Posted - 2007-01-19 : 13:35:06

Thanks everyone. I found what to do. Just in case others are looking for the same info, here it is...

1) Create a System DSN thru your Data Sources (ODBC) app in the Admin Tools (Control Panel)
2) You need Video 2003 Enterprise Architect
3) With you ERD open in Visio click on Database->Model->Error Check
4) If you have errors in the model, you cannot create the DB until all errors have been fixed
5) Once the ERD is error free, go to Database->Generate
6) Make sure you select "DDL" and "Generate New Database"

Note: I think it is a good idea to save a copy of the DDL

7) Then Select the driver you will use to connect to the DB. In the case of SQl Server 2005, select Microsoft SQL Server from the drop down list
8) Make sure you click in the Setup button (next to the Driver drop down list so you specify the fields data type mapping
9) Select the data source (created in step 1)
10) Click Finish

meareal
Starting Member

21 Posts

Posted - 2007-01-19 : 13:43:04

I am sorry. Step 2 should read Visio and not Video

Ian83

5 Posts

Posted - 2007-01-20 : 09:50:16

(Spam Removed)

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources