Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 932
  • Last Modified:

SQL 2000 Copy diagram

Is there a way, either when generating SQL scripts or copying a database to also copy the diagram(s)? I am stumped.
thanks
0
Rodney Helsens
Asked:
Rodney Helsens
  • 3
1 Solution
 
HilaireCommented:
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
 
HilaireCommented:
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
 
arbertCommented:
They are in the MSDB database, but they can't simply be scripted out (blobs)....
0
 
HilaireCommented:
Just a link to M$ article on this topic

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

HTH
Hilaire
0
 
Rodney HelsensAuthor Commented:
Thanks Hilaire, that KB 320125 link was exactly what I needed.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now