Problems with Backups
FredMorin
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
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
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.