Search for existing suggestions

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.

Current State:
Generate schema -> update live database schema -> import schema from database into VS DB Project -> check-in

Future State:
Update VS DB Project -> update live database schema -> check-in

4 votes
Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)

We’ll send you updates on this idea

StrandedPirate shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

0 comments

Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
Submitting...

Feedback and Knowledge Base