CODEWITHSUNDEEP
sql-server-2012sql-server-data-tools
Greg McGuffey
Greg McGuffey

Reputation: 3316

Ideas on false positives of schema compare

I have a SQL Data project. When I compare it with my dev database, it is returning a bunch of false positives. They are all functions (but not all the functions, just some of them). I can see no difference. I've done diffs of the source shown in the compare window (copy paste into UltraEdit). I've diffed the source file with the script produced by the server. I've tried messing with the encoding. I've checked the EOLs. In ALL cases, there are no differences to be found (the compare tool shows no differences either...i.e. while the function is marked as being different, no differences actually show in the object definitions area).

Any ideas on what is causing this and how I can clear it up?

Upvotes: 2

Views: 541

Answers (1)

Nick.Mc
Nick.Mc

Reputation: 19184

I have the same issue. When I apply the DB to the project, they remain false positives.

However when I apply the project to the DB, the false positives go away.

So, to clear it up, compare the project to the DB, and Update the DB from the project for the troublesome objects.

Upvotes: 2

Related Questions