Cannot Create Database Project - Cannot load file or assembly "Microsoft.SqlServer.Management.SqlParser"

Couple of days ago I’ve format my computer, a fresh start .

Today I tried to open a Database project I’m working on and I got the following error message:

Of course I’ve installed SQL 2008 + with Management Studio and all the other things coming with Visual Studio 2010, but I did make some changes to the 2008 R2 installation… I wanted to remove the Default SQL Express coming with Visual Studio and install the complete suite.

During this process I’ve removed several SQL installations from my machine and this what cause the problem, the SQL Management is working just fine but there are still something missing….

So after couple of minutes investigating the Visual Studio modules I found which installations required for Creating Database Project in Visual Studio 2010.

Enter Microsoft® SQL Server® 2008 R2 Data-Tier Application Framework v1.1 Feature Pack download site, download and install the following:

64bit:

1. DACFramework.msi
2. TSqlLanguageService.msi
3. SQLSysClrTypes.msi
4. SharedManagementObjects.msi

32bit:

1. DACFramework.msi
2. TSqlLanguageService.msi
3. SQLSysClrTypes.msi
4. SharedManagementObjects.msi

Enjoy