Consider the following scenario:
- We have a SSDT database project.
- We add a new column to the middle of a table.
- We publish this SSDT database project with the setting “Block incremental deployment if data loss might occur” enabled.
- This forces the database project to rebuild the table in order to deploy the change.
- Because we have the above setting enabled, the deployment (correctly) throws an exception saying data loss may occur.
My question is this: Can we rely on the fact that whenever the table needs to be rebuilt as part of a SSDT publish this error will be thrown?
Aucun commentaire:
Enregistrer un commentaire