Unable to create a SQL Server 2012 projects in Visual Studio 2010 - by jm98

Status : 

  By Design<br /><br />
		The product team believes this item works according to its intended design.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 731860 Comments
Status Closed Workarounds
Type Bug Repros 1
Opened 3/18/2012 2:19:53 PM
Access Restriction Public


64-bit Window 7 Ultimate SP1
VS2008 9.0.30729.4462 QFE
VS2010 Ultimate 10.0.40219.1 SP1Rel
SQL Server 2008 R2 10.50.2500.0

After installing SQL Server 2012 RTM, VS 2010 still only presented 2005 and 2008 database project types eventhough SSIS, SSRS & SSAS BIDS projects were now available.

Sign in to post a comment.
Posted by Janet Yeilding on 8/9/2012 at 9:32 AM
You can generate a change script in SSDT by starting a Publish operation and clicking Generate Script in the Publish dialog.

SSDT does not contain a data generation tool at this time.

Let me know if you have any further questions.

Janet Yeilding
janety at microsoft dot com
Posted by Mbowles on 8/9/2012 at 9:25 AM
SSDT and the 2005/8 database projects are so different as to be unrelated. Where is my data generation, where is my script creation for diffs between code and actual db so they can be created, deployed and sourced?
Posted by Janet [MSFT] on 4/2/2012 at 4:50 PM
It looks like you're trying to use VS2010 Database Projects, which can't target SQL Server 2012 and have been replaced by SSDT. Please download SSDT at the following location http://msdn.microsoft.com/en-us/data/hh297027, then make sure to navigate to the SQL Server node when creating a new project. There is only one project type for targeting SQL Server 2005, 2008, 2008 R2 and 2012 (target is specified in project properties).

Hope this helps
-Janet Yeilding
janety at microsoft dot com
Posted by nojetlag on 3/22/2012 at 9:01 AM
The interop between VS and SQL Server gets worse and worse, these are really some simple basics, why do you make it so complicated ? I want to develop SQL 2012 projects with VS2010 without having to install SQL 2012 locally.