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 !
Top comments (0)