Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 How to copy database diagrams?

Author  Topic 

markshen2006
Starting Member

15 Posts

Posted - 2008-04-18 : 11:51:30
Hi,

I remember I asked the similar question before.But I have not solve this.

I am working with SQL Server 2005. I just make a copy of the production database.

I use "tasks -> Generate Script" to copy the table structure and use "tasks -> import Data" to copy Data. But I can not copy the database diagrams,I need to keep the primary keys - foreign keys relations.

Please let me know how to copy database diagrams.I try many ways but I can not figure it out.

Thanks for your help

Mark



jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2008-04-19 : 05:20:16
http://www.sqljunkies.ddj.com/Article/3CE3B885-9798-4F24-B29D-84D111FEF876.scuk

Jack Vamvas
--------------------
Search IT jobs from multiple sources- http://www.ITjobfeed.com
Go to Top of Page
   

- Advertisement -