Using SDK 10 to compare database backup with live database

[Bastiaan Molsbeck]

Hi,

I am looking for sample code to data compare a database backup file with a live database, and process the differences into the live database.
Background info: the backup file is from a production server and the live database is a test server which should be updated to the latest version, including data.

When searching the RedGateWiki I found a page which describes that this is possbile, and even has a link to a sample project:
Page: http://sdk.red-gate.com/index.php/SQL_Comparison_SDK
Project: http://sdk.red-gate.com/uploads/5/5d/SDCCompareToBackup.zip

But that sample project is created with an old version of the Comparison SDK, which does not compile against version 10.
For instance, the references "RedGate.SQL.Shared" and "RedGate.SQLCompare.BackupReader" doesn't exist in version 10 anymore.

Where can I find an up-to-date sample for this scenario?

Kind regards,
Bastiaan.

[Brian Donahue]

Hello Bastiaan,

I have created an updated sample for comparing data in a live database against a backup. Hopefully this helps!

http://sdk.red-gate.com/index.php/Comparing_backup_to_live_database
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521

[Bastiaan Molsbeck]

Thank you! This helps me very much.