Post reply

Comparing two backup files

  • April 24, 2006 at 2:45 pm

    #113011

    I have a user who asked an interesting question, is it possible to compare two SQL Server database backup files to see if they are different? Is it also possible to compare two databases in enterprise manager? Thanks in advance for your help.

    Ken

  • April 24, 2006 at 2:59 pm

    #633901

    In order to compare 2 database backups, you must restore both of them.  Enterprise manager will not compare databases for you.  There many third party tools that will do this for you such as Red-Gate's SQL Compare, or DB Ghost.  If you only need to complare schemas (and not data), you could use any basic diff tool by restoring your databases, using EM to generate script files, and comparing the text based script file using any basic diff tool (Win Diff, Beyond Compare, ExamDiff).

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

  • April 25, 2006 at 8:16 am

    #634032

    Thanks that is what I thought!

     

  • July 31, 2018 at 2:16 am

    This was removed by the editor as SPAM

  • October 21, 2018 at 7:23 pm

    This was removed by the editor as SPAM

  • October 21, 2018 at 7:26 pm

    This was removed by the editor as SPAM

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

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