Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Visual Studio gets stuck on opening a sql project

We are trying to setup a sql project, in 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.

Tried re-installing SSDT, VS 2010 but no help.

Created a new database project for Northwind db, and had the same issue. Ran procmon and saw it's just going over and over the same files.

It works fine in another system with similar configuration.

EDIT

The issue seems to be related to TFS, if we unbind from TFS it works fine. But not sure about the exact cause.

Any suggestion would be really helpful.

like image 236
Baga Avatar asked Jul 02 '14 10:07

Baga


People also ask

Does Visual Studio work with SQL?

SQL Server Data Tools for Visual Studio. Turn Visual Studio into a powerful development environment for SQL Server, Azure SQL Database and Azure SQL Data Warehouse.

How do I connect Visual Studio to SQL Server Management Studio?

Right click on 'Data Connections' then click 'Add Connection'. On the next screen (Choose Data Source) change the data source ensure 'Microsoft SQL Server' is selected then click the 'Continue' button. In the 'Server name' field enter 'SQL-SERVER'. Change the 'Authentication' method to 'SQL Server Authentication'.


2 Answers

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

like image 166
superlogical Avatar answered Oct 21 '22 07:10

superlogical


I deleted the .suo file in the .vs folder in the root of solution directory. This fixed it for me. I think this is the best and least damaging answer as it preserves your modified files and some of your other settings (of course some settings such as your start up project will be lost)

like image 40
atreeon Avatar answered Oct 21 '22 07:10

atreeon