Skip to content

Dacfx fails to publish the dacpac while creating the non-clustered index when table has disabled clustered index #386

@ssreerama

Description

@ssreerama
  • 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:

  1. Create a table and create clustered index and non-clustered indices
  2. Disable the clustered index (Engine will automatically disables the non-clustered index)
  3. Extract the dacpac
  4. 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)

Metadata

Metadata

Assignees

Labels

Type

No type

Projects

No projects

Milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions