Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 930
  • 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

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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