We are trying to set up a SQL project, on a new machine with Windows 7, VS 2010 with SP1 & SSDT 2010 (installed SSDT 2010 from ISO image). But getting the below message when I open the sqlproj:
Verifying your model is synchronized with your source files. Your database will be ready in 12734 operations are completed.
And the number keeps on increasing. And it keeps on running in the background.
I tried re-installing SSDT and VS 2010 but it did not help.
I created a new database project for Northwind DB, and had the same issue. I ran procmon and saw it's just going over and over the same files.
It works fine in another system with a similar configuration.
The issue seems to be related to TFS, if I unbind from TFS, it works fine. But I am not sure about the exact cause.
My suggestion is if you are using source control such as Git and you have just switched branches and you are hitting this issue is to use git clean which will remove untracked files (which VS and SSDT are choking up on)
git clean -fdx
Not sure what to use if you are on TFS or SVN or HG.. but same idea applies