Solved

SQL 2000 Copy diagram

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

Forrester Webinar: xMatters Delivers 261% ROI

Guest speaker Dean Davison, Forrester Principal Consultant, explains how a Fortune 500 communication company using xMatters found these results: Achieved a 261% ROI, Experienced $753,280 in net present value benefits over 3 years and Reduced MTTR by 91% for tier 1 incidents.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
removing unwanted rows from an sql server ranked table 13 37
SQL Select Query help 1 38
Searching a barcode number within a string. 7 27
SQL Server Express or Standard? 5 34
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
I have a large data set and a SSIS package. How can I load this file in multi threading?
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

730 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