SQL Compare failing to detect data compression

mwjdavidson

I'm using SQL Compare 8.1.0.360 to compare a physical SQL Server 2008 database in which page-level data compression has been applied to all tables to a set of scripts. Where a difference other than the compression exists for a given table, the table correcly appears under the "objects that exist in both but are different" section. However, where the only difference is the compression setting, the table only appears within the "identical objects" section. Curiously, selecting such a table in this section to display the scripts shows the difference with highllighting!
Has anyone else experienced this?

Thanks

Mark

dshort

yes, I've seen the same thing

Brian Donahue

Hi,

Can you please upgrade to 8.5 using Check for Updates and try again? It won't cost you anything and I think there is a bugfix for DATA_COMPRESSION=PAGE.

dshort

Brian Donahue wrote:

Hi,

Can you please upgrade to 8.5 using Check for Updates and try again? It won't cost you anything and I think there is a bugfix for DATA_COMPRESSION=PAGE.

Hi Brian:

I'm was on 8.50.12.18. Just downloaded and upgraded to 8.50.12.20, but it's got the same problem.