I work for a small agency and we often have more than one developer working on a magento project. We work locally, and then commit to github after each phase of development. The problem we are having is managing the database content.
Currently, each developer takes a sql dump of their local database and pushes that to github as part of the commit. We have a system that takes the github repo and pushes that to a staging server. Part of the system grabs the sql dump file and updates the staging server db.
The problem we have is that if dev 1 has - for example - created a bunch of cms pages, and dev 2 has installed and configured some modules, merging the 2 sql files is very difficult, and we end up spending way too much time merging the two dbs.
Can anyone suggest a better workflow process to handle this?