What are the challenges you face when working across database platforms? Take the survey
Options

Compression differences not detected

scurrpsascurrpsa Posts: 3
edited September 8, 2015 9:41AM in SQL Compare 11
When comparing schema differences, Index compression settings are not compared or applied when deploying changes.

Project options says not to ignore compression.
Deploy via SQL Script.

For example -
Same index , one with compression one without - not detected as a difference
New index with compression, Index is created without the compression setting.

SQL Compare V 11.2.1.82
Comparing SQL 2008 R2


is there something else I need to configure?

Regards
Pete

Comments

  • Options
    Hi Pete,

    I think this is happening because SQL Compare ignores filegroups by default, and compression is (kind of) a filegroup property.

    In the project options, could you try unchecking the option to ignore "filegroups, partition schemes and partition functions"?

    I hope this solves your problem.
    Software Developer
    Redgate Software
  • Options
    Hi Sam,

    I excluded that ignore option and re-compared, no data compression differences detected.
    I turned off all ignore options and re-compared, no data compression differences detected.

    I looked at the *.spc file and I could see the exclusions being added and removed as I changed them.
    My "my documents" folder is on a network share, not in the default location. not sure if that causes an issue.
    I also don't run as an account with local admin permissions.

    Regards
    Pete
  • Options
    Just adding a reply in case others are reading this thread...

    I believe Anu from Support contacted Peter and it was established that one of the databases was in 2005 compatibility mode. SQL Compare ignored the difference because compression isn't supported in SQL Server 2005.
    Software Developer
    Redgate Software
Sign In or Register to comment.