Skip navigation

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

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

insert into
   <targetdb>..dtproperties
select
   object_id, value, lvalue, version
from
   <sourcedb>..dtproperties


Hide comments

Comments

  • Allowed HTML tags: <em> <strong> <blockquote> <br> <p>

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.
Publish