All geek questions in one place

What is the best way to split two database backup files using MS Sql Server 2005?

I have two database backup files. I would like to know if there is a difference between the two. I could go along the lines, across the field and make diff (I am not looking for differences in the scheme, but rather the data, although I expect the scheme to remain the same).

Can I run some checksum for files, or do I need to go through the data to be 100% sure?

+3
source share
3 answers

Restore both backups to a temporary database (you may need to use “WITH MOVE” to rename the logical name) and then use a tool such as DataGrid Data Compare.

+3
source

I think you will have to go through the data that I think, since I expect the file will have dates and other things in it that will ruin any checksums that you could calculate.

Something like Apex SQL Data Diff is pretty good, but there are many tools for differentiating. You will need to restore the backups to temporary databases in order to be able to run this, though.

0
source

Source: https://habr.com/ru/post/1703659/

More articles:


All Articles