Moving a database diagram to another database

Hello, all. Was wondering if I can move a diagram I've created in Database
A to Database B, which is on the same SQL SERVER...with different db names
of course. I'm running SQL 2K. If this possible, please let me know
Tia
RozThe diagrams are stored within dtproperties. You might be able to move =
the data via DTS, BCP or some other method.
--=20
Keith
"Roz" <anonymous@.discussions.microsoft.com> wrote in message =
news:9B5F1E93-A3AE-4B51-8146-F4B0278C12D4@.microsoft.com...
> Hello, all. Was wondering if I can move a diagram I've created in =
Database A to Database B, which is on the same SQL SERVER...with =
different db names of course. I'm running SQL 2K. If this possible, =
please let me know
>=20
> Tia
> Roz
>=20
>|||Keith Kratochvil wrote:
> The diagrams are stored within dtproperties. You might be able to move th
e data via DTS, BCP or some other method.
>
I was wondering the same thing as Roz, I've just had a quick look into using
DTS
or BCP to copy the diagram over... it doesn't look like it's possible?
Have you done this or was it just a suggestion? I'd like to be able to do th
is.
Regards,
Craig.|||Found this right after posting...
Microsoft Knowledge Base Article - 320125
HOW TO: Move a Database Diagram
http://support.microsoft.com/?scid=kb;en-us;Q320125
Regards,
Craig.|||check this out, I found it at
http://www.sqlmag.com/Articles/Index.cfm?ArticleID=7225
SET IDENTITY_INSERT dtproperties
ON
INSERT
dtproperties
([id],objectid,property,value,
lvalue,version)
SELECT
[id],objectid,property,value,
lvalue,version
FROM
pubs..dtproperties
WHERE
pubs..dtproperties.objectid = 8
SET IDENTITY_INSERT dtproperties
OFF
Regards,
Craig.