I’ve often thought about creating something that can manage changing field names, as well as removing data when a field is removed, but I can never find the time for it and it’s low on my personal priority list. I’ve also been very careful about making sure that I don’t run into a situation where it necessary…
although, I do have a site that I need to modify right now, not the same problem, but similar. I created a select field for a client with 3 possible values and now they want to change one of those values which means that I have to go digging through the database and create a some type of query to alter the values stored in more than 5K product posts.
