Comparing a database with a backup file

Automate and integrate using the SQL comparison API

Moderator: Chris Auckland

Comparing a database with a backup file

Postby margiu » Wed Feb 23, 2011 8:50 pm

Do you have any example for comparing and synchronizing a database with a backup file??
margiu
 
Posts: 2
Joined: Wed Feb 23, 2011 8:44 pm

Postby Brian Donahue » Thu Feb 24, 2011 12:08 pm

Brian Donahue
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am

Postby margiu » Fri Feb 25, 2011 11:36 am

Thanks Brian, but I've a problem with the example code "Compare live database data to a backup". In line 30
IList<IBackupSet> backupSets = backupDB.GetBackupSets(files, passwords);

SQLBackupReaderLoadException: Cannot load the Backup Reader dll!
margiu
 
Posts: 2
Joined: Wed Feb 23, 2011 8:44 pm

Postby Brian Donahue » Fri Feb 25, 2011 12:50 pm

Yep, probably should have mentioned that the BackupReader code is 32-bit only. Normally you can compile your SDK project as AnyCpu, but once you reference the Backup Reader you have to compile your code as x86 code.
Brian Donahue
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am


Return to SQL Comparison SDK Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests