SSDT & TFS: SQL Server Database Comparison Does Not Work

Question

I have a database project with SSDT (SQL Server Data Tools) in Visual Studio 2015 and TFS source control.

This morning, when I tried to compare two databases (DB → TFS), this did not work, and I received an error message:

Comparison completed. The difference is found. Limited comparison. See the Error List for more details.

And in the window of the error list window was:

Severity code Description Project file line suppression status Warning The input for the target does not have a VIEW ANY DEFINITION. The comparison will be limited to the database if the source is a database.

SQL Server user for SSDT was sa.

Thanks in advance

---

UPDATE: , :

USE [master]
GO

Grant VIEW ANY DEFINITION to [USERNAME];
GO

USE [DBNAME]
GO

GRANT CONNECT to [USERNAME]
GRANT VIEW DEFINITION TO [USERNAME]

Answer 1

, drop recreate object MSSQLServer:

Answer 2

. , :

• Schema Compare , - "".
• " " .
• - (CR LF) unix (LF).
• (Brute force solution) sqlpackage.exe, .dacpac , .zip model.xml - - .