Visual Studio Database Project integration
Support for updating a Visual Studio Database Project(s) instead of updating the db directly with an ad-hoc file.
Currently 4.0 allows us to generate our database schema from the model but its capabilities are limited and destructive:
unique keys – no support
schema generation – destructive
Database Projects for Visual Studio has already matured and more importantly has the capability of updating schemas without being destructive to the data. It would be nice to see the next designer integrate fully with this product rather than re-invent the wheel. For those of us that manage our databases using Database Projects this will also reduce the amount of steps needed to get our database schemas checked into source control.
Generate schema -> update live database schema -> import schema from database into VS DB Project -> check-in
Update VS DB Project -> update live database schema -> check-in