I'd like to have my database schema synchronized with my Visual Studio .dbproj database project.Right now, I'm using SSMS for most of my database development work, and I've to manually use the schema compare tool of visual studio when I need the db schema and the .dbproj to be synchronized. Why would I want this? because :It's the only way to checkin changesIt's the only way to apply changesFailure to do so will cause some merge issues when getting files (basically, if a get latest contains some db changes on db objects I've been updating whithout checking them out, a merge won't be triggered, and it's easy to keep track of which version is which)It's nice to be able to use the search features of VisualStudio on an up-to-date version of the schemaIt's nice to be able to modify stored procedures from VS (typically when you have renamed a file) using the search results.Apart from automating the schema compare tool to have it run every 5 minutes (which hardly sounds like a clean solution), are there ways to achieve this ?I'd like to keep using SSMS if possible, but I'm also interested in ways to automatically propagate changes made using the Server Explorer/Database connections of visual studio to the .dbproj. 
How can I keep my visualstudio database project in sync with my database?
version control;visual studio 2010;database development;team foundation server