S
Scot Becker
Hi Everyone,
I've released a first stab at a bit of XSLT that will transform the Visio
Database Model Diagram XML Output from the Orthogonal Toolbox
(http://www.orthogonalsoftware.com/products.html) into SQL DDL:
http://www.orthogonalsoftware.com/files/OTERtoSQL.xslt
You may need to tweak it a bit for your DBMS (I have only really used MS SQL
Server as my test platform), but it should be mostly compatible.
This would be useful if you are stuck with Visio Professional (which won't
forward engineer databases at all) or if you want more control over DDL
generation in Visio.
Any comments or suggestions would be welcome.
FYI,
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.
I've released a first stab at a bit of XSLT that will transform the Visio
Database Model Diagram XML Output from the Orthogonal Toolbox
(http://www.orthogonalsoftware.com/products.html) into SQL DDL:
http://www.orthogonalsoftware.com/files/OTERtoSQL.xslt
You may need to tweak it a bit for your DBMS (I have only really used MS SQL
Server as my test platform), but it should be mostly compatible.
This would be useful if you are stuck with Visio Professional (which won't
forward engineer databases at all) or if you want more control over DDL
generation in Visio.
Any comments or suggestions would be welcome.
FYI,
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.