Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL Server Database diagram Expand / Collapse
Author
Message
Posted Tuesday, April 28, 2009 8:59 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, May 5, 2009 4:23 PM
Points: 5, Visits: 9
Hi,

I tried to copy the SQL Server 2000 database diagram from one database to another database in my local server through ALL task-> the Export wizard-> Query as "Select * from dtproperties". While doing it so it got copied. When i open the diagram in the new database ,the relationship integrity are vanishing and only tables are available. Can anyone help me how to retain the relationship too?

Thanks,
Gayathri
Post #706434
Posted Tuesday, April 28, 2009 9:43 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 10:20 PM
Points: 2,994, Visits: 2,591
The relationships disappear from the diagram because they are not in the database you copied the diagram to. The diagram does not actually contain the relationships. It simply draws them if they exist in the database. It does store the layout of the line drawn to represent the relationship but if the relationship is not actually in the database, the information in the diagram relating to the relationship is removed.

The same applies to tables and columns that are shown on the diagram.

You will need to create the relationships in the new database.



Post #706445
Posted Tuesday, May 5, 2009 4:24 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, May 5, 2009 4:23 PM
Points: 5, Visits: 9
Thank you very much!
I did in the same way and it is working fine
Post #710716
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse