title: How do I move diagrams between SQL Server databases?
body: <p>I'm trying to move a database from a hosted server to my own SQLExpress instance.  I used the Database Publishing Wizard to create the script... but the diagrams were not transferred.  </p>
  
  <p>Then, I found and followed the advice of another answer on this site that had me import/export the data to the sysdiagrams table.</p>
  
  <p>When I do that, I see all of the diagrams in the Diagrams folder. However, when I try to open one, I see an outline of each table, then get a popup error message that says:</p>
  
  <p>"Table(s) were removed from the diagram because privileges were removed to these table(s) or the table(s) were dropped."</p>
  
  <p>When I exit from the popup, all of the tables are removed from the diagram (except for a couple of aspnet_xyz membership tables that were part of one diagram).</p>
  
  <p>Do you know how I can transfer the diagrams without receiving this message?</p>