Problems with Backups

Automate and integrate using the SQL comparison API

Problems with Backups

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

The following line works with a NOT COMPRESSED MST Backup

but hangs with a compressed one


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..


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
Posts: 7
Joined: Wed Nov 26, 2008 10:21 pm

Postby Brian Donahue » Mon Dec 01, 2008 11:12 am

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: 6590
Joined: Mon Aug 23, 2004 9:48 am

Return to SQL Comparison SDK Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests