Method for tracking differences between production and development databases to perform an automatic synchronization

摘要

Embodiments disclosed herein relate to systems, methods, and computer program products for updating a development database. In some embodiments, the system and method compare a development database and an associated production database to determine a drift score. The development database is then updated when the drift score exceeds a predetermined threshold. In some situations, the system extracts a schema from the development database and the associated production database in order to identify differences between the two databases. The system then calculates a drift score based on the differences and compares the drift score to a predetermined threshold value. If the drift score exceeds the threshold value, the system alerts the user to update the development database or automatically updates the development database.