Code to compare backups in C#

[mturaga]

Is there any resources for comparing the backups.
I wanted to do a
Differences dbSourceVsdbTarget = dbSource.CompareWith(db, Options.Default);

where db is a backup , How do I instanciate the backup datasource in the db above?. db is a backup location as in widgetdev.bak

[Brian Donahue]

Hello Maruthi,

If you are simply looking for an example of comparing the schema of a backup file to a live database, a sample is available here:
http://labs.red-gate.com/index.php/Compare_to_Backup

It shouldn't be too much of a leap to modify this to compare two backups if that's what you need to do. Lots of code examples are available on the labs website.
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521