Restore "Database Diagrams" (sql 2k)?

  • One of our developers had a ton of database diagrams in a Claims database. He tells me today that they are missing (?) and he needs them back. 

    I will try restoring an earler copy of that database to another server to see if the diagrams are present. If they are, how can I transfer them to the new database?

    TIA,

    Bill

     

    P.S. This situation is problematic. Suppose the diagram from the earlier restore references a table that has been deleted or modified in the current database!

     

     

     

  • Here it is


    * Noel

  • No need to leave this site. Brian Knight has an article on this here http://www.sqlservercentral.com/columnists/bknight/transferdiagram.asp

    Grin, curious what the forum software will do wiuth the hyperlink

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • Yep, but Microsoft posted Officially there, so I went straight from the horses' mouth


    * Noel

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply