title: How do you migrate SQL Server Database Diagrams to another Database?
body: <p>My team recently rebuilt their SQL Server 2005 development database from scratch using the TFS source files.</p>
  
  <p>Afterwards, we had a nice clean database that more closely matched our test and production environments. However, we also lost the database diagrams that had been created over the months in the old development database.</p>
  
  <p>Does anyone know of a way to export a SQL Server 2005 database diagram from one database to another that contains the same tables and schema objects?</p>
  
  <p>UPDATE:</p>
  
  <p>Both Valentin and CMS's answers below should work just fine. I accepted Valentin's because it was first and I had already started using it.</p>
  
  <p>I ended up creating a temp table called 'robsysdiagrams' and copied all the data into that and used the <a href="http://www.microsoft.com/downloads/details.aspx?familyid=56E5B1C5-BF17-42E0-A410-371A838E570A&amp;displaylang=en" rel="noreferrer">Microsoft SQL Server Database Publishing Wizard</a> to script the data inserts out to disk. I then renamed robsysdiagrams to sysdiagrams in the script and ran it on the destination database. Everything worked fine.</p>