SQL Source Control For Data Updation
We have gone though SQL source control and it workd perfectly with our Mercurial repository for schema changes. We also want some data changes to be source controlled like in some master tables , we have added some values. We want that these values should be added in the target database with the schema changes when the target db update itself by taking latest, so this type of feature i available in RedGate or we have to do some manual work for data changes. Kindly guide. Thanks
This feature is implemented as the Static Data feature of SQL Source Control. More details on https://documentation.red-gate.com/display/SOC5/Link+static+data