patternsqlMinor
DACPAC Deployment Rebuilding All Indexes
Viewed 0 times
alldacpacindexesdeploymentrebuilding
Problem
I'm in process of deploying a DACPAC provided by our ISV. The DACPAC is rebuilding every index in the database. We're testing in a Lab now, however, this will create a significant impact to our maintenance window when we move into production. Is anybody aware how I can skip this index rebuild process in the DACPAC deployment?
Solution
The most likely reason this is happening is because there are different options / settings on the indexes in the model (the dacpac file) and the target (your actual database). The deployment, by default, will rebuild the index with the new options to get the target to match the model.
There are two deployment options you can enable to avoid this. I would try them one at a time to see which one is causing the rebuild:
There are two more options that ignore index-related things (
There are two deployment options you can enable to avoid this. I would try them one at a time to see which one is causing the rebuild:
/p: IgnoreIndexOptions=True
/p: IgnoreLockHintsOnIndexes=TrueThere are two more options that ignore index-related things (
IgnoreFillFactor and IgnoreIndexPadding). These are enabled by default, but you might want to check and make sure your publish process isn't explicitly setting them to False.Code Snippets
/p: IgnoreIndexOptions=True
/p: IgnoreLockHintsOnIndexes=TrueContext
StackExchange Database Administrators Q#247115, answer score: 2
Revisions (0)
No revisions yet.