Problems with Backups

[FredMorin]

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

[Brian Donahue]

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
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521