April 24, 2006 at 2:45 pm
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
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).
April 25, 2006 at 8:16 am
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