?
Solved

SQL 2000 Copy diagram

Posted on 2004-04-13
5
Medium Priority
?
925 Views
Last Modified: 2007-12-19
Is there a way, either when generating SQL scripts or copying a database to also copy the diagram(s)? I am stumped.
thanks
0
Comment
Question by:Rodney Helsens
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
5 Comments
 
LVL 26

Expert Comment

by:Hilaire
ID: 10813613
I think the diagrams are stored along with the DTS packages in the msdb catalog
Script out msdb objects and you should get what you need.

HTH

Hilaire
0
 
LVL 26

Expert Comment

by:Hilaire
ID: 10813884
Oops,
sorry for this misleading first post,
sounds like diagrams are stored in the dtproperties table

I guess it should be possible to rebuild the dagrams with an insert ... select statement

insert into <NewDB>..dtproperties (objectid, value, lvalue, version, property)
select objectid, value, lvalue, version, property
from <SourceDB>..dtproperties

but I'm not sure how it will handle tables having different objectIDs in both databases

Hilaire
0
 
LVL 34

Expert Comment

by:arbert
ID: 10813889
They are in the MSDB database, but they can't simply be scripted out (blobs)....
0
 
LVL 26

Accepted Solution

by:
Hilaire earned 500 total points
ID: 10813970
Just a link to M$ article on this topic

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q320125

HTH
Hilaire
0
 
LVL 9

Author Comment

by:Rodney Helsens
ID: 10815090
Thanks Hilaire, that KB 320125 link was exactly what I needed.
0

Featured Post

Get proactive database performance tuning online

At Percona’s web store you can order full Percona Database Performance Audit in minutes. Find out the health of your database, and how to improve it. Pay online with a credit card. Improve your database performance now!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.
Suggested Courses

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question