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>

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