2

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?

2

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:

/p: IgnoreIndexOptions=True
/p: IgnoreLockHintsOnIndexes=True

There 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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.