April 28, 2009 at 8:59 pm
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
April 28, 2009 at 9:43 pm
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.
May 5, 2009 at 4:24 pm
Thank you very much!
I did in the same way and it is working fine 🙂
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply