SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Designing a Database with Microsoft Visio 2000


Designing a Database with Microsoft Visio 2000

Author
Message
bmsjr
bmsjr
Mr or Mrs. 500
Mr or Mrs. 500 (573 reputation)Mr or Mrs. 500 (573 reputation)Mr or Mrs. 500 (573 reputation)Mr or Mrs. 500 (573 reputation)Mr or Mrs. 500 (573 reputation)Mr or Mrs. 500 (573 reputation)Mr or Mrs. 500 (573 reputation)Mr or Mrs. 500 (573 reputation)

Group: General Forum Members
Points: 573 Visits: 6
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/bszabo/visiodesign.asp


Bruce Szabo, MCSE+I, MCDBA, MCSD
mikesteadman
mikesteadman
Forum Newbie
Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)

Group: General Forum Members
Points: 7 Visits: 1
sorry, dude- I went through the entire article, then realized that I couldn't perform the most important step - which is "creating" the database. There is no "generate" option in my Visio2000 installation. I even reinstalled, but still no "generate". I'm not sure what to do now, I searched the help files, but found nothing.



a7856320
a7856320
Grasshopper
Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)

Group: General Forum Members
Points: 10 Visits: 1
I can't find the 'Generate Database Wizard' either. Running Visio 2000 SR1.



David Benoit
David Benoit
SSCoach
SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)

Group: General Forum Members
Points: 15848 Visits: 3650
You poor folks must be with me and only have the professional edition where I believe Bruce has the Enterprise edition. See MS comments from overview of product;

"Microsoft Visio® 2000 offers two editions created specifically for software and database developers. Visio 2000 Professional Edition provides drawing support for industry-standard notations, with tools to automatically document existing projects. And Visio 2000 Enterprise Edition gives you even more advanced modeling capabilities, including the ability to automatically generate database schema and source code."

Looks great though and nice job Bruce!

David

David

@SQLTentmaker

“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
bmsjr
bmsjr
Mr or Mrs. 500
Mr or Mrs. 500 (573 reputation)Mr or Mrs. 500 (573 reputation)Mr or Mrs. 500 (573 reputation)Mr or Mrs. 500 (573 reputation)Mr or Mrs. 500 (573 reputation)Mr or Mrs. 500 (573 reputation)Mr or Mrs. 500 (573 reputation)Mr or Mrs. 500 (573 reputation)

Group: General Forum Members
Points: 573 Visits: 6
I am sorry I always forget to mention the Enterprise Edition is the one this feature works with. Man, I wish MS would get it straight. Sorry about that, although if you were contemplating upgrading it is a great reason to upgrade. At the time I upgraded I was actually more interested in mapping network diagrams.

Bruce

Bruce Szabo, MCSE+I, MCDBA, MCSD


Bruce Szabo, MCSE+I, MCDBA, MCSD
reinh
reinh
SSC Veteran
SSC Veteran (286 reputation)SSC Veteran (286 reputation)SSC Veteran (286 reputation)SSC Veteran (286 reputation)SSC Veteran (286 reputation)SSC Veteran (286 reputation)SSC Veteran (286 reputation)SSC Veteran (286 reputation)

Group: General Forum Members
Points: 286 Visits: 107
And what about Visio 2002 Enterprise Edition?
Can we generate a database scheme from here?

If not, can we move a vsd-file from Visio 2002 to 2000?



miketash
miketash
Grasshopper
Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)

Group: General Forum Members
Points: 11 Visits: 16
I read your article and couldn't help thinking why anyone would want to use Visio to model a database when you can do this within SQL itself?



Andy Warren
Andy Warren
SSC-Forever
SSC-Forever (44K reputation)SSC-Forever (44K reputation)SSC-Forever (44K reputation)SSC-Forever (44K reputation)SSC-Forever (44K reputation)SSC-Forever (44K reputation)SSC-Forever (44K reputation)SSC-Forever (44K reputation)

Group: Moderators
Points: 44858 Visits: 2783
I fall into that camp of "why use Visio" myself. Great tool, but so far I've found EM & diagrams to do a pretty good job. Open to discusson though:-)

Andy
http://www.sqlservercentral.com/columnists/awarren/

Andy
SQLAndy - My Blog!
Connect with me on LinkedIn
Follow me on Twitter
bmsjr
bmsjr
Mr or Mrs. 500
Mr or Mrs. 500 (573 reputation)Mr or Mrs. 500 (573 reputation)Mr or Mrs. 500 (573 reputation)Mr or Mrs. 500 (573 reputation)Mr or Mrs. 500 (573 reputation)Mr or Mrs. 500 (573 reputation)Mr or Mrs. 500 (573 reputation)Mr or Mrs. 500 (573 reputation)

Group: General Forum Members
Points: 573 Visits: 6
Well it seems as though I have hit on a topic for discussion.

I looked at Microsoft's site and it does not seem as though they even carry a Visio Enterprise anymore. It seems as though they only have Vision Standard and Visio Professional.

The brochure mentions you can Reverse Engineer databases with the product but it does not mention generating the databases. I will do some more research but I believe you can generate diagrams with Visio 2002.

Bruce Szabo, MCSE+I, MCDBA, MCSD


Bruce Szabo, MCSE+I, MCDBA, MCSD
bmsjr
bmsjr
Mr or Mrs. 500
Mr or Mrs. 500 (573 reputation)Mr or Mrs. 500 (573 reputation)Mr or Mrs. 500 (573 reputation)Mr or Mrs. 500 (573 reputation)Mr or Mrs. 500 (573 reputation)Mr or Mrs. 500 (573 reputation)Mr or Mrs. 500 (573 reputation)Mr or Mrs. 500 (573 reputation)

Group: General Forum Members
Points: 573 Visits: 6
To Andy's point I agree that SQL may have tools that can help you out. In my case though and I did not spell it out in the article but I took a FoxPro database, reverse engineered it and then output it in Access and then SQL. Visio worked great in this case with the only caveat being I had to be careful with data types.

The other solution could have been to upsize to SQL and then try what you suggested although I am not familiar with those tools at all.

Maybe that would be a good topic for another article. Smile Thanks for the feedback!

Bruce Szabo, MCSE+I, MCDBA, MCSD


Bruce Szabo, MCSE+I, MCDBA, MCSD
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum







































































































































































SQLServerCentral


Search