Designing a Database with Microsoft Visio 2000

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Bruce Szabo » Designing a Database with Microsoft Visio...

12 posts, Page 1 of 2

1 2 »»

Designing a Database with Microsoft Visio 2000

Rate Topic

Display Mode

Topic Options

Author

Message

bmsjr

Posted Tuesday, July 16, 2002 12:00 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, March 12, 2009 9:06 AM
Points: 171, 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

Post #5493

mikesteadman

Posted Monday, July 22, 2002 8:01 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, June 04, 2003 12:00 AM
Points: 1, 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.

Post #37637

a7856320

Posted Monday, July 22, 2002 8:46 AM

Forum Newbie

Group: General Forum Members
Last Login: Friday, June 20, 2003 12:00 AM
Points: 4, Visits: 1

I can't find the 'Generate Database Wizard' either. Running Visio 2000 SR1.

Post #37638

David Benoit

Posted Monday, July 22, 2002 9:53 AM

SSCrazy

Group: General Forum Members
Last Login: Tuesday, May 21, 2013 7:56 AM
Points: 2,063, Visits: 3,441

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
SQL Tentmaker
“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

Post #37639

bmsjr

Posted Monday, July 22, 2002 12:35 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, March 12, 2009 9:06 AM
Points: 171, 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

Post #37640

reinh

Posted Monday, July 22, 2002 2:19 PM

SSC Veteran

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 6:27 AM
Points: 249, Visits: 84

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?

Post #37641

miketash

Posted Monday, July 22, 2002 3:18 PM

Forum Newbie

Group: General Forum Members
Last Login: Monday, May 20, 2013 9:56 PM
Points: 3, Visits: 14

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?

Post #37642

Andy Warren

Posted Monday, July 22, 2002 4:59 PM

SSCertifiable

Group: Moderators
Last Login: Thursday, May 09, 2013 12:38 PM
Points: 6,462, Visits: 1,384

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 Smile

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

Andy
SQLShare - Learn One New Thing Each Day
SQLAndy - My Professional Blog
Connect with me on LinkedIn
Follow me on Twitter

Post #37643

bmsjr

Posted Monday, July 22, 2002 7:30 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, March 12, 2009 9:06 AM
Points: 171, 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

Post #37644

bmsjr

Posted Monday, July 22, 2002 7:33 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, March 12, 2009 9:06 AM
Points: 171, 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. :) Thanks for the feedback!

Bruce Szabo, MCSE+I, MCDBA, MCSD

Bruce Szabo, MCSE+I, MCDBA, MCSD

Post #37645

« Prev Topic | Next Topic »

12 posts, Page 1 of 2

1 2 »»

Permissions