How can we help you today? How can we help you today?

SQL Compare failing to detect data compression

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
mwjdavidson
0

Comments

3 comments

Sort by
  • dshort
    yes, I've seen the same thing
    dshort
    0
  • 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.
    Brian Donahue
    0
  • dshort
    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.
    dshort
    0

Add comment

Please sign in to leave a comment.