Visual Studio and .NET Framework Home
Schema Compare does not support the specified database
as By Design
10/14/2009 10:11:40 AM
User(s) can reproduce this bug
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.
Visual Studio 2008 SP1
Windows XP Professional
Operating System Language
Steps to Reproduce
Create a web (ASP.NET) project, add a new database under app_data folder. Configure a couple of tables inside the DB.
Add a new Database 2005 Wizard project, import the database schema
Go to Data->Schema Compare -> New Schema Comparison.
Select your database project as the Source Schema and the database as the Target Schema. Click OK
Microsoft Visual Studio
Schema Compare does not support the specified database.
Results of the comparison and a SQL script.
TAP Code (if applicable)
You can indicate your satisfaction with how Microsoft handled this issue by completing this quick
3 question survey
to post a comment.
Please enter a comment.
on 10/29/2009 at 10:25 AM
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.
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.
to post a workaround.
Please enter a workaround.
© 2014 Microsoft