I came across some vb macros that export it to a mdb ( ms access ) file. But does not work very well when copying forward constraints , etc.
I want generate schema from the database diagram for sql server 2005 database.
+1
A:
(For Visio 2007, as that's what I have to hand, although I remember that 2003 was very similar)
From the Database menu, select "Options" > "Drivers...", and change the default driver to suit.
Rowland Shaw
2009-03-12 13:13:04
i thought this only work for reverse engineering database schema ?
dotnetcoder
2009-03-12 17:06:41
I tried it on my box before posting, and it certainly changes the available datatypes to suit nvarchar(max), etc. I strongly suspect that it wouldn't change existing values though
Rowland Shaw
2009-03-12 17:17:17
A:
Forward Engineering is supported only in "Enterprise Architect" versions of Visio
Lenin Raj Rajasekaran
2010-04-08 07:12:01
http://office.microsoft.com/en-us/visio/FX102144891033.aspx
Lenin Raj Rajasekaran
2010-04-08 07:12:30