|
|
|
|
Database diagrams are stored in the 'dtproperties' table within the database. So, database diagrams can be transferred to a different database, by transferring the contents of this table.
For example , run the following query to transfer the diagram named 'MyTableDesign' from 'pubs' database to 'northwind': |
 Click here to copy the following block | INSERT northwind..dtproperties
SELECT objectid, property, value, lvalue, version
FROM pubs..dtproperties
WHERE objectid =
(
SELECT objectid
FROM pubs..dtproperties
WHERE value='MyTableDesign'
) |
Make sure, the tables referenced by these diagrams already exist in the target database, or else these diagrams won't show up in the target database.
If the target database already has a diagram with the same 'objectid', you will see unpredictable results, when Enterprise Manager displays the diagrams. In that case, you might want to explicitly specify a unique value to the 'objectid' column while transferring rows from the source 'dtproperties' table.
|
|
|
|
|
|
|
Submitted By :
Nayan Patel
(Member Since : 5/26/2004 12:23:06 PM)
|
 |
|
|
Job Description :
He is the moderator of this site and currently working as an independent consultant. He works with VB.net/ASP.net, SQL Server and other MS technologies. He is MCSD.net, MCDBA and MCSE. In his free time he likes to watch funny movies and doing oil painting. |
|
View all (893) submissions by this author
(Birth Date : 7/14/1981 ) |
|
|