Data Compare - update only changed columns in generated SQL
For the Data Compare feature in the database projects in Visual Studio, please allow an option for the generated UPDATE statements to include only the columns which actually have changes. E.g. if a table has 15 columns and only one column has changed, the update statement generated should only SET that one column, and not all 15.
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