Problems with Backups

Automate and integrate using the SQL comparison API

Moderator: Chris Auckland

Problems with Backups

Postby FredMorin » Thu Nov 27, 2008 5:11 pm

The following line works with a NOT COMPRESSED MST Backup

but hangs with a compressed one

backupDB.RegisterForDataCompare(backupDBSource.ToConnectionProperties())

Since I will send the backup by email to clients, I need it to be small.

Is that a bug, a limit of the tool, or is there something else i need to do..

Thanks

ETA: I figured out a workaround using ICSharpCode.SharpZipLib to zip in unzip in my app before calling the code.

But I am still curious as to why it didn't work
FredMorin
 
Posts: 7
Joined: Wed Nov 26, 2008 11:21 pm

Postby Brian Donahue » Mon Dec 01, 2008 12:12 pm

Hi Fred,

SQL Data Compare can read compressed files produced by our own SQL Backup software, but not Microsoft backups that have been compressed using ZIP, for instance.

If this is a SQL Backup file, it might be worth noting that the backup reader process can take a bit of time, so in a few cases it has appeared to hang up but if you watched the process in Task Manager, you would see activity.
Brian Donahue
 
Posts: 6668
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