What are the challenges you face when working across database platforms? Take the survey
Options

Problems with Backups

FredMorinFredMorin Posts: 9
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

Comments

  • Options
    Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    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.
Sign In or Register to comment.