Re: Exporting diagram

#1

Check the following article:
HOW TO: Move a Database Diagram
http://support.microsoft.com/?id=320125

-Sue

On Tue, 19 Aug 2003 21:44:21 GMT, "Niels Meyer"
<webmaster (AT) elsen (DOT) be> wrote:

Quote:

When using the DTS to copy a db from my local MSSQL to the remote server
(connecting via IP address) everything is copied ok except the diagram
laying out the relations. The table relations *are* copied because the damn
thing works as expected also on the remote server.

I figured out so much that the diagrams are saved in the sysfile
'dtproperties' but when copying using the DTS query tool from local to
remote this table is not visible.

I need to remove some relations on certain tables when bulk loading new data
and was just wondering how I got to copy the diagram (as opposed to creating
a new diagram on the remote server and adding relations manually).

Thanks a lot for any ideas,
Niels

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: Exporting diagram

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Re: Exporting diagram - 08-19-2003 , 06:14 PM