How can I transfer database diagrams from one SQL 7 server to another?

Neil Pike

April 7, 1999

1 Min Read
ITPro Today logo in a gray background | ITPro Today

A. Assuming you have identical databases and the dtproperties tableexists on the target db then use :-

insert into
   ..dtproperties
select
   object_id, value, lvalue, version
from
   ..dtproperties

Sign up for the ITPro Today newsletter
Stay on top of the IT universe with commentary, news analysis, how-to's, and tips delivered to your inbox daily.

You May Also Like