How to propagate data changes between dev, qa, and production

We do CRUD operation for admin master tables & write scripts whatever changes make with values and store it to one tracking table in Dev environment. We will run those scripts in other environments by hand(Is there any tool or what is the best approach to run other environment?). Here we are facing one issue the primary key value is not same in other environments.We have almost 10000 record in that table.Kindly share your input how to handle this situation.