Should SQL Data Compare 13 be able to read SQL 2014 compressed backup file as a target?

hbuckner · September 20, 2017 8:51PM

I am not able to set a SQL 2014 compressed backup file as a target. When I rerun the backup uncompressed it works fine.

hbuckner · September 22, 2017 4:06PM

Any info?

way0utwest · September 22, 2017 4:08PM

This is correct. A known issue that we don't support compressed native backups. We support SQL Backup compressed backups: https://documentation.red-gate.com/display/SDC12/Working+with+backups

hbuckner · September 22, 2017 4:12PM

Thanks You.

parscott · December 8, 2017 2:25PM

This is a deal breaker for me....
"You can't compare compressed backups from SQL Server 2012 or later."

Answers