- SqlPackage or DacFx Version: All
- .NET Framework (Windows-only) or .NET Core: both
- Environment (local platform and source/target platforms): Any
As per the docs we cannot Create non-clustered index when the table has its Clustered index disabled. But when the source database has both indexes and cluster is disabled, extracting the dacpac and publishing ii is failing. As the deployment plan has the steps for creating clustered index and then disabling it and later it tries to create the non-clustered index.
Steps to Reproduce:
- Create a table and create clustered index and non-clustered indices
- Disable the clustered index (Engine will automatically disables the non-clustered index)
- Extract the dacpac
- Publish the dacpac to a new database, publish fails due to clustered index was created and disabled first and then creating non-cluster index fails.
Did this occur in prior versions? If not - which version(s) did it work in? No
(DacFx/SqlPackage/SSMS/Azure Data Studio)