views:

161

answers:

0

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 default 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.

related questions