Results 1 to 3 of 3

Thread: Export SQL Server database diagram

  1. #1
    Tim Guest

    Export SQL Server database diagram

    I have a database diagram in SQL Server 7.0. Is there a way to export a diagram to another database?

    Also, is there a way to export a diagram to another server?

    When you DTS, it doesn't dts the diagram and I can't find anything pertaining to the diagram in any of the system tables.

    Thanks.

  2. #2
    Reddy Guest

    Export SQL Server database diagram (reply)

    u have to take the backup of that database and then restore in ur new database or new server. then u'll get every thing incl diagram also.
    u cant transfer the diagram thru dts . bcoz its not database objet like table,view etc. so u can backup the database and restore. thatz it.
    ok cheers
    reddy


    ------------
    Tim at 11/9/00 1:52:23 PM

    I have a database diagram in SQL Server 7.0. Is there a way to export a diagram to another database?

    Also, is there a way to export a diagram to another server?

    When you DTS, it doesn't dts the diagram and I can't find anything pertaining to the diagram in any of the system tables.

    Thanks.

  3. #3
    Magnus Andersson Guest

    Export SQL Server database diagram (reply)

    Check this article:
    http://www.swynk.com/friends/knight/transferdiagram.asp

    There is a better way though, but can't seem to find that article.

    /Magnus

    ------------
    Tim at 11/9/00 1:52:23 PM

    I have a database diagram in SQL Server 7.0. Is there a way to export a diagram to another database?

    Also, is there a way to export a diagram to another server?

    When you DTS, it doesn't dts the diagram and I can't find anything pertaining to the diagram in any of the system tables.

    Thanks.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •