Exporting Database Diagrams - SQL server 2005

Hi,

I'm trying to export my Database Diagrams to a new database. I've managed to do it by right clicking on the database->tasks>export data and followed the wizard instructions. The tables and Data Diagram show up fine on the new database however all the primary keys/relations/ are not present. Is there a way of copying the whole diagram to include all the primary keys and table relations?

Thanks :)

There is more info here:

http://msdn2.microsoft.com/en-us/library/ms171977(VS.80).aspx

But it sounds like there may be some SSIS options you need to set. Which destination are you using? And why export the diagram?

|||

Articles at the link above just give a primer on how to work with diagram designer: add/remove a table, add a note and the like, save the diagram as an object in its database.

The original question (and mine too) is - how to export the diagram outside of its database? At least maybe in a form of an image, if something like a Visio diagram is too much.

Personally, I like SQL Server's diagrams look and feel (for most part), the very much desired but missing functionality is copying a diagram into another database of the same structure. But if you think about it, the other DB does not have to be of the same structure, because the designer is perfectly capable of updating the diagram that you have saved before making changes to your schema! So how about that?