Using SDK 10 to compare database backup with live database

Automate and integrate using the SQL comparison API

Moderators: Chris Auckland, David Atkinson, Michelle Taylor, chengvoon.tong

Using SDK 10 to compare database backup with live database

Postby Bastiaan Molsbeck » Mon Jul 16, 2012 3:20 pm

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/SD ... Backup.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.
Bastiaan Molsbeck
 
Posts: 48
Joined: Fri Mar 26, 2010 11:12 am
Location: The Netherlands

Postby Brian Donahue » Tue Jul 17, 2012 5:56 pm

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/Compa ... e_database
Brian Donahue
 
Posts: 6668
Joined: Mon Aug 23, 2004 10:48 am

Postby Bastiaan Molsbeck » Wed Jul 18, 2012 3:57 pm

Thank you! This helps me very much.
Bastiaan Molsbeck
 
Posts: 48
Joined: Fri Mar 26, 2010 11:12 am
Location: The Netherlands


Return to SQL Comparison SDK 10

Who is online

Users browsing this forum: No registered users and 0 guests