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 changes
- It's the only way to apply changes
- Failure 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 schema
- It'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.