SharpDeveloper
Copy A Database Diagram To Another Database
For some reason SQL Server doesn’t have an easy way to "Create TO" for database diagrams, unlike stored procedures, functions ,etc.
Here is how you can achieve moving a database diagram (or copying a database diagram) in SQL Server 2005
use Old_Database go --this will copy your database diagrams into a temporary table select * into dbo.#tempsysdiagrams from sysdiagrams use New_Database go insert into sysdiagrams ([name],principal_id,version,definition) select [name],principal_id,version,definition from dbo.#tempsysdiagrams where [name]='Name_of_your_Diagram'
That’s it, so easy.
Related Reading:
Other Interesting Posts
4 Responses to Copy A Database Diagram To Another Database
Leave a Reply Cancel reply
-
Articles
- January 2011
- April 2010
- March 2010
- February 2010
- January 2010
- August 2009
- July 2009
- June 2009
- May 2009
- April 2009
- February 2009
- December 2008
- November 2008
- October 2008
- July 2008
- June 2008
- May 2008
- April 2008
- March 2008
- February 2008
- December 2007
- November 2007
- October 2007
- September 2007
- August 2007
- July 2007
- June 2007
- May 2007
-
Meta








Why post a blob and cover it with ads so you cannot read the content. Quite silly.
Looks fine on my monitor, anyway you can “view plain” or “copy to clipboard” if you like
Thanks a lot. It helps me today. Thank you very much.
I ended up using an open query due to databases living on a different sever. Worked for me as well, thanks.