Visio 2003 Prof and ER Diagram Forward Engineer

[r6dude]

Folks,

I know this has been asked zillion times. I need to move my huge ER
diagram from Visio 2003 Prof to some sort of SQL schema without paying
for .Net Ent Arch Edition. Is there any way this can be done???

I am using the Orthogonal Toolbox to export to a XML file but how abt
to a DDL?

Thanks

aj

 

[Scot Becker]

I know this has been asked zillion times. I need to move my huge ER

diagram from Visio 2003 Prof to some sort of SQL schema without paying
for .Net Ent Arch Edition. Is there any way this can be done???

I am using the Orthogonal Toolbox to export to a XML file but how abt
to a DDL?

On my website (http://www.orthogonalsoftware.com/toolboxaddons.html) is an
XSLT file that can be used to convert the XML into basic SQL Server DDL.
Feel free to tweak it if you want to customize the generation. To use it,
among other ways, you can export the XML using this file as the "stylesheet"
and then open the resulting file in IE. From there, you can cut and paste it
into Query Analyzer.

Scot.
...........................
Scot Becker

Orthogonal Software
www.orthogonalsoftware.com

ORM Protal/Blog: www.objectrolemodeling.com

 

[Ajay Agrawalla]

thanks scott. appreciate it.