Schema Compare does not support the specified database - by DashNYC

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.


1
0
Sign in
to vote
ID 497755 Comments
Status Closed Workarounds
Type Bug Repros 0
Opened 10/14/2009 10:11:40 AM
Access Restriction Public

Description

I have Visual Studio Team System Team Suite 2008 with SP1, latest updates and 
Microsoft® Visual Studio Team System 2008 Database Edition GDR R2 (http://www.microsoft.com/downloads/details.aspx?FamilyID=bb3ad767-5f69-4db9-b1c9-8f55759846ed&displaylang=en) installed.

In a database project, when I go t to Data -> Schema Compare -> New Schema Comparison, if I select a database that's part of a web project inside my solution as either Source or Target Schema, I get an errror "Schema Compare does not support the specified database" This doesn't happen if I select a Project as both Source and Target.

It seem the tool doesn't support attached databases on SQL Express. No problems when using a database on a remote DB server.
Sign in to post a comment.
Posted by Microsoft on 10/29/2009 at 10:25 AM
CodePoetry,

Thank you for reporting this issue. The GDR version of the product does not support RANU or Single Instance Mode Databases. This is under consideration for supporting in the next version of the product.

Posted by Microsoft on 10/15/2009 at 9:38 PM
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.

Thank you