Visual Studio 2010 Premium Database Projects and SQL Server 2012 RTM - by DannyV-Netformx

Status : 

  Fixed<br /><br />
		This item has been fixed in the current or upcoming version of this product.<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 730701 Comments
Status Closed Workarounds
Type Bug Repros 8
Opened 3/12/2012 10:58:35 AM
Access Restriction Public


After updating SQL Server from 2008 R2 to 2012 RTM schema comparison with VS Database Projects will not work on database.

Error message: "Schema Compare does not support the specified database."
Sign in to post a comment.
Posted by Microsoft on 3/22/2012 at 11:41 AM
Please install SQL Server Data Tools to target SQL Server 2012 (and many more benefits and improvements!). You can install it on top of your Visual Studio 2010 + SP1 from here: for free, and use the new SQL Server database project type (you can convert your existing .dbproj's) and the new Schema Compare tool. Learn more about the different between the previous .dbproj's and the new SSDT .sqlproj's and toolset on the team blog and links at the site above.

Re: the comment about data compare: Yes, similarly, the previous VS2010 tools cannot target the new SQL Server 2012. SSDT is where to go for this in almost cases, but does not yet have Data Compare -- it will though!

Sarah McDevitt
Posted by Microsoft on 3/21/2012 at 7:24 AM
Thanks for your feedback.

We are rerouting this issue to the appropriate group within the Visual Studio Product Team for triage and resolution. These specialized experts will follow-up with your issue.
Posted by ProVega on 3/19/2012 at 3:53 PM
FWIW - The data compare tool flat out says "Versions higher than 2008 R2 are not supported". Lame.
Posted by Stoonad on 3/14/2012 at 7:22 AM
Simple to reproduce for me.

Start VS 2010, click on Data -> Schema Compare -> New Schema Comparison

In the Source Schema, choose a SQL 2008 R2 server/database.

In the Target Schema, choose a SQL 2012 (RTM) server/database.

Click OK.

Error message: Schema Compare does not support the specified database.

Happens every time.
Posted by MS-Moderator10 [Feedback Moderator] on 3/12/2012 at 11:26 PM
Thanks for reporting the issue.
In order to fix the issue, we must first reproduce the issue in our labs. We are unable to reproduce the issue with the steps you provided.

It may help if you provide us with:
a setup log file

You can get the log files with the following steps:
1) Download collect.exe from the link below. <>
2) You may choose to save the tool for later use, or to run directly.
3) The utility creates a compressed cabinet of all the VS and .NET logs to %TEMP%\

You can get more details about how to get the log files here:

Thanks again for your efforts and we look forward to hearing from you.
Microsoft Visual Studio Connect Support Team
Posted by MS-Moderator01 on 3/12/2012 at 11:48 AM
Thank you for your feedback, we are currently reviewing the issue you have submitted. If this issue is urgent, please contact support directly(