Visual Studio 2010 deploys views too late in deploy process

Posted by Markus on Stack Overflow See other posts from Stack Overflow or by Markus
Published on 2010-05-05T06:20:58Z Indexed on 2010/05/05 6:28 UTC
Read the original article Hit count: 163

I have a database project in my VS2010 solution. I recently changed a view and and changed a number of functions to use this view instead of going directly against a table. But now when I deploy I get errors on most of these functions because the column asked for does not exists in the view yet. The update of the view happends later than the update of UDF's. Is there any way to change this behaviour? Wouldn't the best thing be if the deploy script updated in this order: tables, views, SP and UDF. It seems like tables is updated first, but the views are just thrown in somewhere in the middle of the deploy script.

© Stack Overflow or respective owner

Related posts about visual-studio-2010

Related posts about database