Solved

SQL 2000 Copy diagram

Posted on 2004-04-13
5
923 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 125 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

What Is Transaction Monitoring and who needs it?

Synthetic Transaction Monitoring that you need for the day to day, which ensures your business website keeps running optimally, and that there is no downtime to impact your customer experience.

Question has a verified solution.

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

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
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 shrink a transaction log file down to a reasonable size.
Viewers will learn how the fundamental information of how to create a table.

719 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