SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,875 questions
SSDT DEployment fails with "The Element or Annotation class SqlIndex does not contain the Property class Online"
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(153.6, 23%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERA%3C/text%3E%3C/svg%3E)
Ron Anoshi
10
Reputation points
Trying to deploy our DBs SSDT, both in an Azure Pipeline and on our team's Docker, fails with the following error:
Assembly Initialization method <MyAssembly>.ComponentTestBase.AssemblyInit threw exception. Microsoft.Data.Tools.Schema.Sql.Deployment.DeploymentFailedException: Microsoft.Data.Tools.Schema.Sql.Deployment.DeploymentFailedException: The Element or Annotation class SqlIndex does not contain the Property class Online. ---> Microsoft.Data.Tools.Schema.SchemaModel.ModelSerializationException: The Element or Annotation class SqlIndex does not contain the Property class Online.. Aborting test execution.
When looking at the SSDT generated script, is shows that indeed all of our indexes, though created with the Online property, as can be seen in model.xml: <Property Name="Online" Value="True" /> The script is generated without:
WITH (ONLINE = ON)
This suddenly started happening, without any related changes, and fails on old master versions as well, and the internet claims it has something to do with later version mismatches of SqlPackage.exe.
A solution would be greatly appreciated.