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