What is a good way to manage developers' data changes?
I am using RedGate SQL Source Control to monitor changes to tables and stored procecures, so that when we do a production build, I can include all the changes in a SQL update script.
My question is: what is a good way to consolidate and monitor changes made to the data? (As this is something RedGate Source Control cannot track)
For example, new records included in lookup tables? And new records included in tables used for routing procedure calls. Thank you!