Saturday, August 22, 2015

Rows were detected. The schema update is terminating because data loss might occur

When deploying an updated database you could encounter the following error:
"Rows were detected. The schema update is terminating because data loss might occur"

You could turn off the check for data loss as follows:

1) In the solution explorer, right click on you project and choose "Publish ..."
2) I the Publish dialog box choose "Advanced ..."
3) Uncheck "Block incremental deployment if data loss occurs"

No comments: