Baseline compression enabled
EricLamontagne
Posts: 45 Bronze 3
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
Tagged:
Best Answer
-
Ivo_Miller Posts: 31 Silver 3Hi,
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.Ivo Miller
RedGate Software Developer