We are deploying our dacpac with changes to a partition scheme and function. During the deployment we get an error
Invalid partition scheme '...' specified
When we look at the deployment script we see that the partition scheme is first dropped, then a temporary table 'tmp_ms_xx_...' is created with a reference to the partition schema that was just dropped!? At the end of the script we see that the partition scheme is created.
Does anyone know why the script is generated this way resulting in an obvious error?