sql server dts: I copied a diagram from one server to the another one.
The tables in the diagram copied over, but not the
relationships.

A diagram ?

Are you referring to diagrams of your SQL Server structure or do you mean
the tables and their keys and relationships ?

If you used the DataPump task then you will not have moved the relationships
between tables. You can remedy this by scripting them out from EM.

Right click the DB | All tasks | Generate SQL Script

You could also have used the Transfer objects task and specified to bring
across indexes as well.

--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org



[quoted text, click to view]