Database project should allow deployment of reference data tables
Some tables in our projects contain configuration or reference data.
There should be a way to maintain this data versioned as anything else.
Either having a source database for comparison and automatic generation of SQL to deploy to another database or keeping data in source files that would be deployed diferencially during database deployment would do.
This data is the hardest to maintain nowadays, no method (human-error-free) garanties that during a deployment reference data gets updated correctly
Thanks for taking the time to share this suggestion. This item has been around for a couple of versions of Visual Studio and we haven’t acted on it. Looking at the VS “15” plans, we’re not going to take action on this item, so we’re going to close it. If the suggestion is still relevant, please either take a look to see if there’s another suggestion that’s similar that you can vote on, or open a new suggestion.
- The Visual Studio Team