Sometimes it is necessary to alter the schema of a database to introduce new features or change the current features of an application.
Usually the new or changed application features are tested first in a development environment.
When the new developments are ready to go in production, it is necessary to update the schema of the database in production to have the same structure of the database in the development environment.
This class provides a solution for this problem by comparing the schemas of the database in the development and production environments and performing the necessary alterations to synchronize the schemas.
This class provides a way to synchronize the schema of one or more databases from the schema of a master database.
Currently, the class only synchronizes the database schema, not data in the database tables.
For now it supports MySQL databases but the schema manipulation functions are implemented in a separate driver class. Therefore, support for other types of databases can be implemented by writing new driver classes.
When I started to work in a virtual team comprising of 6 developers , I felt that the most time consuming task was syncing the database changes amongst team members...