Compression differences not detected

scurrpsa

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

sam.blackburn

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.

scurrpsa

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

sam.blackburn

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.