Baseline compression enabled

EricLamontagne

Hi,

Is it possible to enable table compression when creating the base line?

My source database as compression, but the baseline does NOT include any compression, am I missing some settings?

Regards,

Eric

Ivo_Miller

Hi,

I believe the setting you want is SyncOptionIgnoreDataCompression (True by default), documented here:
https://documentation.red-gate.com/sca/developing-databases/concepts/advanced-concepts/comparison-and-script-generation-options

You can set this before baselining in Visual Studio (by opening up the settings file on disk before completing the setup wizard), but not yet in SSMS.
You can set it after baselining in both.
The ability to set this before baselining in SSMS via the UI will likely be released this week.