mercredi 4 février 2015

Under what conditions does SSDT fail on deployment due to "Data Loss May Occur"


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