Post reply

How to copy diagram from one db to another on same server

  • February 1, 2006 at 3:59 pm

    #112371

    I know you can view the diagram icon, highlight it and click Cut or Copy, but if I go to another database with the same exact schema, how do I "paste" that diagram?

    Thanks!

  • February 1, 2006 at 9:08 pm

    #618279

    Far as I know it can't be done...is the data different between the 2 databases..if not, then your best bet would be to do a full backup and restore!!!







    **ASCII stupid question, get a stupid ANSI !!!**

  • February 1, 2006 at 9:12 pm

    #618280

    There's no data in the db yet, I was just trying to replicate from another db in the quickest manner possible.

    I have my script for the tables and sproc creation, but just wanted to see if there was a way to include the diagram.  It's only about 11 tables, so it's not biggy!

    Thanks!

  • February 1, 2006 at 9:41 pm

    #618283

    Haven't done this myself, but try copying the dtproperties table across to the new database. This is where the meta-data for the diagram is stored.

     

    --------------------
    Colt 45 - the original point and click interface

  • February 2, 2006 at 3:34 am

    #618325

    I did it by copying dtproperties and it worked fine. Here is the MS way just for reference: http://support.microsoft.com/default.aspx?scid=kb;en-us;Q320125

     

  • February 2, 2006 at 6:43 am

    #618367

    I was going to "poke around" today to see where it was stored...thanks Phill & Allen..one more nugget of info to store in the knowledgebase...







    **ASCII stupid question, get a stupid ANSI !!!**

  • February 2, 2006 at 7:35 am

    #618392

    Awesome!  Thank you guys!  This is perfect!

Viewing 7 posts - 1 through 6 (of 6 total)

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