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.
| Author |
Topic |
|
Leopic
Starting Member
1 Post |
 Posted - 2003-06-12 : 23:19:07
|
| Hello.I have a DB with a relationship diagram in a SQL Server and I need to make a mirror of this DB in another SQL Server. I've generated the script to create the DB in the destination server, but when I create the DB, the Relationship Diagram does not appear. ¿Any idea how to solve this?Thanks in advance.Leo |
|
|
byrmol
Shed Building SQL Farmer
1591 Posts |
Posted - 2003-06-13 : 00:00:30
|
| SQL Server stores this information in the dtproperties table of each database.So it is a simple matter of moving this whole table to the new database.If the new database does not have any diagrams, then this table probably won't exist.. You can create it my making a simple diagram, you don't even have to save it...DavidM"SQL-3 is an abomination.." |
 |
|
|
|
|
|
Replicating a Relationship Diagram