Right way to work with C5 database in team1 user found helpful
What is your workflow for developing C5 projects in team?
I mean, let's imagine, that 2 developers are working with the same website simultaneously. And at some moment they have to merge their changes with each other.
So, in case of files - it's easy, we just need to use GIT for that. But what for database? How can we merge changes in DB? What is the correct workflow for C5 project?
Back up both of the databases (eg, using CPanel/mysqldump).
Unpack each backup (if necessary) to get the .sql file.
Use a text editor or utility to compare the files. This will highlight any changed lines.
Merge the changes as you see fit.
Upload ('restore') the modified .SQL.
Presumably the most important changes will be to table structure rather than contents. You could refine this approach to help you find structural changes only.
You would need to set up some platform which you specify the tables that *may* change and then compare any difference and pick which is right or merge them manually.
Usually when you make database edits, you do not ever move a development database up to a staging/live site. You should write patching SQL files which contain the changes and timestamp the filenames. When you put your new git repo live, run the sql files in date order.
Still searching for something much complex I think. Some approach that will help to merge databases in more automated way... And I think this topic is behind C5 issues scope. It's like some kind of DevOps stuff.