Rebuild partition instead of dropping & recreating primary key when only changing data compression
SQL Compare currently attempts to drop and recreate a primary when changing compression.
REBUILD PARTITION ALL WITH (DATA COMPRESSION PAGE|ROW|NONE
would be more efficient and less intrusive since, among other things, it doesn't require dropping and recreating all foreign keys.
2
votes
Rick Thorington
shared this idea