Activity overview
Latest activity by 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 / comments
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 ...
Compression differences not detected
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 ...