Free ER to SQL XSLT Transform

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top