My objective is to get relationships from database A to database B. Please note I can not do a backup and restore, this is not an option.
These three sets of relationships are in three diagrams and having never copied a diagram from A to B before I was thinking that, if I did this the relationships may also come over. The copy went great, simply moving the records from a.sysDiagrams to b.sysDiagrams was easy.
But no relationships came across, damn. What is the best method to copy diagrams including the relationships from A to B?
A fair amount of time was put into creating these. We often want to move a set of tables from Database to database. Most of the time these are on different servers.
for completeness the comment made by Allan S is the answer to this post. I don't believe I can accept his comment since it was only a comment and not an answer?
I would be very interested to know if there is a way to copy a 2008 SQLServer diagram and include the relationships. I assume there is not.