How to script Database diagrams in SQL Server 2005 ?

dvplayltd
dvplayltd used Ask the Experts™
on
Hi experts!

I have some databases in SQL Server 2005 and need to transform diagrams between developer database and real DB. Can I make script of it?
I search here before make ask, but not found solution exactly like I need – I need to save it on plan text file like DDL. I’m not OK to make link to this server and manipulate it like local server. Is this possible ?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Commented:
Hi,

It's not easy but you can export it file following link shows how you can do that.

http://www.codeproject.com/KB/database/ScriptDiagram2005.aspx

Hope it helps

Author

Commented:
10x

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial