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.
From stackoverflow
-
(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.
dotnetcoder : i thought this only work for reverse engineering database schema ?Rowland Shaw : 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 -
Forward Engineering is supported only in "Enterprise Architect" versions of Visio
Lenin Raj Rajasekaran : http://office.microsoft.com/en-us/visio/FX102144891033.aspx
0 comments:
Post a Comment