How do I generate the SQL DDL from Visio to create the database I.

[jbeam]

I used to be able ( in previous versions) to create the DDL from a drawing
but now I can not figure out how to do that in Visio 2003. Can someone point
me to it?
Thanks

 

[Al Edlund]

first of all you have to be using visio enterprise architect which comes
with vs.net enterprise archtiect.
Al

 

[Scot Becker]

I used to be able ( in previous versions) to create the DDL from a drawing

but now I can not figure out how to do that in Visio 2003. Can someone
point
me to it?

Visio Pro 2003 doesn't forward engineer. However, you can use my utility
(Orthogonal Toolbox, free, URL below) to export the model as XML and then
use the provided XSLT (Add-ons page) to render that XML as SQL DDL.

You might have to tweak the XSLT a bit if you are not using MS SQL Server,
but it should be mostly compatible as is.

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.

 

[Wozza]

Hi Scot,

Can your ad-in produce code to add extended properties to SQL columns using
the "Notes" entered for a field? I have not looked at the product yet.

Basically I am looking for a way to add the info that the standard database
export wizard in Visio 2002 does not export to the SQL script it generates.

Is the source for your add-in installed as well?

Warren Roscoe
HP

 

[Scot Becker]

Hi Warren,

Can your ad-in produce code to add extended properties to SQL columns
using
the "Notes" entered for a field? I have not looked at the product yet.

The SQL DDL generation produced by the XSLT relies on the XML output of the
toolbox. The toolbox will export all of the meta-data that is exposed by the
API, which it looks like (from other posts) you have been playing with.
Unfortunately, notes on ER shapes are not exposed and thus not exported.

Basically I am looking for a way to add the info that the standard
database
export wizard in Visio 2002 does not export to the SQL script it
generates.

The Enterprise version might generate this for some drivers (I'd have to
check), but otherwise I think you are out of luck.

Is the source for your add-in installed as well?

Sorry, no.

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.

 

[Timothy Ketron]

Hi, I can repair any scratches, dents or bumper repairs on your car, also
leather seats...........perfect repairs