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
> 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
thanks scott. appreciate it.
