Search code examples
sql-serverredgatedatabase-versioning

Commit only part of changes in SQL Source Control

I'm currently testing RedGate's Sql Source Control (Version 3.1.3.26).

I have a table with static data which stores a SQL statement in each line.
Is there a way to only commit parts of the changes?
For example I changed 5 rows but I want to select only 3 of them for commiting.

I'm thinking of a functionality similar to one which is provided by RedGate's Data Compare, where I can decide for each row indiviually if it should be included in the deployment script.

Is this possible or do I have only the possibility to commit the complete changes of a table?

Solution

  • Currently you must commit all of the table data changes. You may want to chime in on Red Gate's uservoice page about the ability to filter static data.