How to fix a partition issue in a bacpac backup

_{Photo by Emmanuel Ikwuegbu on Unsplash}

In order to fix it, we need to perform 6 steps:

• rename the .bacpac file to .zip extension
• extract model.xml and origin.xml
• open model.xml and change the entry

 <Entry> <Element Type="SqlPartitionValue"> <Property Name="ExpressionScript"> <Value><![CDATA[NULL]]></Value> </Property> </Element> </Entry> 

to

 <Entry> <Element Type="SqlPartitionValue"> <Property Name="ExpressionScript"> <Value><![CDATA[CAST(NULL AS DATETIME2)]]></Value> </Property> </Element> </Entry> 

• Save, and compute the new checksum using Powershell cmdlet Get-FileHash:

Get-FileHash -Algorithm 256 model.xml 

• write the checksum in origin.xml to replace previous model.xml checksum
• Put back files model.xml and origin.xml in zip

Hope it helps !