Home Dashboard Directory Help

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


 as By Design Help for as By Design

Sign in
to vote
Type: Bug
ID: 731860
Opened: 3/18/2012 2:19:53 PM
Access Restriction: Public
User(s) can reproduce this bug


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 Microsoft 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.
Sign in to post a workaround.
Posted by Hossein Aarabi on 3/31/2012 at 2:31 PM
Install and use SQL Server Data Tools (SSDT). You can create database projects for SQL Server 2005, 2008, 2008 R2, 2012, Azure.
Posted by jm98 on 3/20/2012 at 3:04 AM
1) Uninstall VS2010
2) Install SQL Server 2012
3) Install VS2010
4) Install VS2010 SP1

However, the database project template appears under "Other languages" as opposed to "Database --> SQL Server" which is where SQL2008 appears