Visual Studio 2010 Database Project does not understand Schema Names anymore?

Posted by Xenan on Stack Overflow See other posts from Stack Overflow or by Xenan
Published on 2010-04-23T14:12:31Z Indexed on 2010/04/23 14:13 UTC
Read the original article Hit count: 170

Filed under:

VS2010

|

database-project

|

visual-studio-2010

|

database-schema

I just tried to upgrade a Visual Studio 2008 Database project to VS2010 and actually it is quite a mess. Hundreds of warnings, all unsolved references. It seems to boil down to Visual Studio not to understand Schema Names (aka Ownership) anymore. For example, the standard dbo schema:

[$(MyDataBase)].dbo.MyTable

is fine but:

[$(MyDataBase)].myschema.MyTable

gives an unsolved reference. It did work in VS2008.

Also the abbreviation for dbo, the double dot:

[$(MyDataBase)]..MyTable

Doesn't work anymore.

In the project property windows I restored the references to the correct servers (which were lost after the conversion) but that didn't help.

This seems pretty basic but I don't have a clue how to solve this. Any help is appreciated.

© Stack Overflow or respective owner

Related posts about VS2010

Uninstall of VS2010 RC gets stuck on uninstall of Crystal Reports templates for VS2010

as seen on Stack Overflow - Search for 'Stack Overflow'
The progress bar is stuck at 100%. Any suggestions for the best/cleanest way torwards a healthy install of VS2010 Final Release? I have this problem all the time with the MS Installer (MSIEXEC.exe/setup.exe). Previously, reinstalling the MS Installer didn't help. >>> More
Insufficient Permissions Problems with MSDeploy and TFS Build 2010

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
I ran into these problems on a TFS 2010 RC setup where I wanted to deploy a web site as part of the nightly build: C:\Program Files (x86)\MSBuild\Microsoft\VisualStudio\v10.0\Web\Microsoft.Web.Publishing.targets (3481): Web deployment task failed.(An error occurred when reading the IIS Configuration… >>> More
Package and Publish Web Sites with TFS 2010 Build Server

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
To package and publish web sites with TFS 2010 Build Server, you can use MSDeploy and some of the new MSBuild arguments. For example: /p:DeployOnBuild=True /p:DeployTarget=MsDeployPublish /p:MSDeployPublishMethod=InProc /p:CreatePackageOnPublish=True /p:DeployIisAppPath="Default Web… >>> More
Web 2.0 Extension for ASP.NET

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
ASP.NET is now much extended to support line of business and data centric applications, providing Web 2.0 rich user interfaces within a native web environment. New capabilities allowed by the Visual WebGui extension turn Visual Studio into a rapid development tool for the web, leveraging the wide… >>> More
Design by Contract with Microsoft .Net Code Contract

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
I have done some talks on different events and summits about Defensive Programming and Design by Contract, last time was at Cornerstone’s Developer Summit 2010. Next time will be at SweNug (Sweden .Net User Group). I decided to write a blog post about of some stuffs I was talking about. Users are… >>> More

Related posts about database-project

VS2010 ultimate DataBase Project + SQL Server 2008: Updating Project from Database

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello everyone, this is a quick question: I have this Database Project in a Web app solution with the real database. I want to update the database using SQL server managment studio, and then update the corresponding VS project. This can be done? I know that you can update the scripts in the project… >>> More
SQL Server schema comparison - leaves behind obsolete files on synchronization

as seen on Stack Overflow - Search for 'Stack Overflow'
Directly related to http://stackoverflow.com/questions/2768489/visual-studio-2010-database-project-is-there-a-visual-way/2772205#2772205 I have a problem synchronizing between database project and a database in Visual Studio. Usually I synchronize FROM database TO database project (using the Visual… >>> More
How to Link VS2010 Database Project and LINQ to SQL

as seen on Stack Overflow - Search for 'Stack Overflow'
As I am working with the new database projects in VS2010, and as I am learning LINQ to SQL, I am curious as to the best way to link the two groups of information so that when I update one, the other updates along with it. From my research here at SO, as well as in Google, it appears the general rule… >>> More
Script all SQL database objects into VS Database project

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm trying to put my database scripts into a VS Database project (I haven't generated them yet). I'm assuming there should be some kind of "auto generate all" functionality, but I can't find anything. Or do I really have to generate them one by one manually from management studio? >>> More
VSDB to SSDT Part 2 : SQL Server 2008 Server Project … with SSDT

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
With Visual Studio 2012 and the use of SSDT technology, there is only one type of database project : SQL Server Database Project. With Visual Studio 2010, we used to have SQL Server 2008 Server Project which we used to define server-level objects, mostly logins and linked servers. A convenient wizard… >>> More