Changes might cause deployment errors

Jesse_T

I'm attempting to add a large database to TFS and am getting an error on the screen where I commit changes.  The error says "These changes might cause deployment errors or data loss.  Please review them carefully.  Its giving me the error on all the build in db_xxx database roles.  Is there a way to get more details about "why" the tool thinks there could be errors?  How do I know if it's safe to commit these database objects to TFS?

Andrea_Angella

I agree it's not the greatest experience but if you click Commit you will be able to see the detailed list of warnings and decide to cancel the operation if you don't want to proceed by clicking the Cancel button.

You can review each warning individually and make the right call.

This is how the dialog looks after you try to commit:



...and this is a list of all the possible warnings you can get with a reason of why the deployment could fail or cause data loss:

https://documentation.red-gate.com/sc13/deploying-data-sources/deployment-warnings/full-list-of-deployment-warnings