Copy A Database Diagram To Another Database

By Sameer On April 19, 2008 · 4 Comments

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.

4 Responses to Copy A Database Diagram To Another Database

WhatiIsThePoint says:

September 14, 2009 at 6:48 am

Why post a blob and cover it with ads so you cannot read the content. Quite silly.

Reply
Sameer says:

September 14, 2009 at 2:42 pm

Looks fine on my monitor, anyway you can “view plain” or “copy to clipboard” if you like

Reply
Irfan Ahmad (Isfan) says:

September 26, 2009 at 7:39 am

Thanks a lot. It helps me today. Thank you very much.

Reply
Justin says:

August 2, 2011 at 8:58 pm

I ended up using an open query due to databases living on a different sever. Worked for me as well, thanks.

Reply