Here's a quick tip for those of us using VSTEDP (DataDude) for database development and TFS (Team Foundation Server) for source control.
You may occasionally see a yellow message stating "External file change, resynchronization required…" when you open a large solution, perform a "get latest version (recursive)" and switch to the schema view. I'm assuming this is a normal behavior since the local schema database may be out of sync with the object scripts just downloaded from the TFS server. If I remember correctly, the DataDude team decided not to "resync" automatically since it may take some time to accomplish on a large scale project. Unfortunately, it's not immediately obvious how to do this unless you mouse over the "Synchronize" icon as shown below:
No, this is not a "Refresh" button as the icon suggests, it's a "Synchronize" button and will bring your Solution Explorer view and Schema View into sync! Keeping these two views in sync is critical since the Schema Compare and Data Compare functions use the local schema database and not the SQL script files.
I know the DataDude team talk about the "one version of the truth" in database development but in reality there are two versions, one in the script files and the other in the local schema database. It's important to keep these two versions of the truth in sync!
Technorati Tags: Visual Studio, DataDude, Team Foundation Server