After Schema Comparison the Solution Explorer still does not update RRS feed

  • Question

  •   In VSTS 2008 Database Edition GDR, I have done a schema compare and the tables which were present in the database project and not in the database got deleted when I have clicked on update. That's fine but when I open the Solution explorer, I still see the sql script of the table. What should I do to update them. In the schema view it has got automatically updated when I wrote updates from Database, then why doesn't it automatically do it in the solution explorer view. Do I need to manually delete them?

    Wednesday, December 10, 2008 7:21 PM


  • Solution Explorer is based on a SQL Server SMO connection and model, which has no concept of invalidation based on server side state changes, you need to manually sync.

    Right click on the tables node inside Solution Explorer and choose Refresh, this will update the stale collections information inside SMO.

    • Marked as answer by StevenPo Tuesday, January 27, 2009 11:40 PM
    Monday, December 22, 2008 8:17 PM