Problem

With a Microsoft Visual Studio Database Project, we can use version control software to manage changes to databases and we may face these problems:

The database project deployment failed, and the error message said “The schema update is terminating because data loss might occur”.

A database object, for example a table, was removed in the project, but the object was still in the target database after a successful deployment.

To know the solution of this problem, please access: https://www.mssqltips.com/sqlservertip/5456/using-advanced-publish-settings-for-visual-studio-database-project/