Sunday, March 25, 2012

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?

sql

No comments:

Post a Comment