Hi guys,
So, we are working in a multi develper environment, using Microsoft DevOps (TFS) as our build/deploy tool with Git as source control.

When one of us makes a change in the MSSQL Backend (we all have local SQL installations), naturally the INT files get changed. We then create a template file of the new database structure.
We have a tool that reads this template file and compares it to a selected DB, to facilitate automatic DB updates.

The problem here arises when the INT file does not match the backend DB (since someone checked in a changed INT file) and the system gets crazy. Our DB Sync tool cannot handle that the INT and DB differs, and so we can't perform the update, resulting in having to manually edit the INT file or DB to make things work.

This is only a problem for developers, not production, since on the prod servers we do not deploy new INT files, but rather just run the sync tool with the new template file and all is fine.

So I wonder how the rest of you work with your INT files? Do you check in the changed files? Or do you just let your DB Sync tools handle everhthing? If so, what sync tools do you use? Or do you still write code to update the DB?

Thanks in advance