How to add revision history or track any changes made by user?

Questions and Answers Database-SQL
3

How to synchronize test /local DB and production DB in case when on local i create/edit some components field, and on production someone add contents ?