Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Designing a Database with Microsoft Visio 2000 Expand / Collapse
Author
Message
Posted Tuesday, July 16, 2002 12:00 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-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
Posted Monday, July 22, 2002 8:01 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, June 4, 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
Posted Monday, July 22, 2002 8:46 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Monday, July 22, 2002 9:53 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 12:19 PM
Points: 2,107, Visits: 3,582
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
Posted Monday, July 22, 2002 12:35 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-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
Posted Monday, July 22, 2002 2:19 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, July 29, 2014 8:45 AM
Points: 280, Visits: 101
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
Posted Monday, July 22, 2002 3:18 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, June 8, 2014 7:15 PM
Points: 3, 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?




Post #37642
Posted Monday, July 22, 2002 4:59 PM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: Moderators
Last Login: Tuesday, August 12, 2014 10:53 AM
Points: 6,783, Visits: 1,876
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
Post #37643
Posted Monday, July 22, 2002 7:30 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-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
Posted Monday, July 22, 2002 7:33 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-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 »

Add to briefcase 12»»

Permissions Expand / Collapse