VS 2010 DB project fails to deploy after upgrade to Sql Server 2012 Error Deploy01234

Question

I have VS2010 Premium and recently upgraded from SQL Server 2008R2 to 2012 Developer Edition. Now when I try to deploy an existing database project (created while using 2008Rs) I get the following error.

Error {name}: The target database schema provider could not be determined

Additionally, I don't see the options for creating a new database project for 2012 from the available project templates in VS, as should be available for the SQL Server Data Tools (which were installed successfully as part of the 2012 upgrade).

Answer 1

With the help of the MS site, I was able to get this resolved.

I (re)installed SSDT from http://msdn.microsoft.com/en-us/data/gg427686, and rebooted. Then opened SSDT up to create a new sql project. I didn't find the new project template for "Sql Server Database Project" at first - for me it appears under Installed Templates/Other Languages/Sql Server. Since I'm not sure if I looked there prior to this test (not an intuitive location), I can't say whether the re-install did the trick. But this got me going.