使用 MS Sql Server 2005 区分两个数据库备份文件的最佳方法是什么? [英] What's the best way to diff two database backup files with MS Sql Server 2005?

问题描述

我有两个数据库备份文件.我想知道两者之间是否有任何区别.我可以逐行、逐个字段进行比较(我不是在寻找模式的差异，而是寻找数据的差异，尽管我希望模式保持不变).

I have two database backup files. I would like to know if there is any difference between the two. I could go row by row, field by field and do a diff (I'm not looking for differences in schema but rather data, although I expect the schema to remain the same).

我可以对文件运行某种校验和，还是必须检查数据本身才能 100% 确定?

Can I run some sort of checksum on the files, or do I have to go through the data itself to be 100% certain?

推荐答案

将两个备份恢复到临时数据库(可能需要使用 'WITH MOVE' 来重命名逻辑名称)，然后使用 RedGate 的 Data Compare 之类的工具.

Restore both backups to temporary database (might need to use 'WITH MOVE' to rename logical name), and then use a tool like RedGate's Data Compare.

这篇关于使用 MS Sql Server 2005 区分两个数据库备份文件的最佳方法是什么?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！