Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Other SQL Server Topics (2005)
 extract & copy 2005 database diagrams

Author  Topic 

mruniqueid
Starting Member

1 Post

Posted - 2007-12-21 : 19:02:34
I have database diagrams in my original db which was built with Management Studio. I now have scripts to build the database from scratch, but my diagrams are left behind, back in the original db. Is there any way to copy the original diagrams into the new db? I know in SS2000 the diagrams were in the dtproperties table; any idea where they are in SS2005?

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-12-21 : 20:11:52
Stored in sysdiagrams table, and don't think you can copy it.
Go to Top of Page
   

- Advertisement -