Generate SQL IN Visio Professional 2003

[Daren Hawes]

Hi,

I just purchased Visio Professional 2003 as it had on the box the
ability to model Databases, and have heard how good it is.

Also how it reverse engineers, but now I have modelled my very large
database, I cannot generate SQL script.

Did I buy the wrong version? Can I Upgrade?

Please help.

Thx Daren

 

[Scot Becker]

I just purchased Visio Professional 2003 as it had on the box the

ability to model Databases, and have heard how good it is.

Also how it reverse engineers, but now I have modelled my very large
database, I cannot generate SQL script.

Did I buy the wrong version? Can I Upgrade?

The Pro version doesn't generate a database; The enterprise architect
version (which comes with visual studio enterprise architect) does.

However, you can download the utility on my website (free, url below) and
the xslt available on the add-ons page which will export the model as XML
and translate it into SQL DDL respectively.

HTH,
Scot.
................................................
Scot Becker

Orthogonal Software
www.orthogonalsoftware.com

ORM Blog: www.objectrolemodeling.com

To e-mail me, please use my first name at the domain listed above. All mail
sent to the reply-to address gets routed to a junk e-mail folder where it
will likely be deleted without being read.