How to work with a database when using Wordpress and GIT?

Question

git

First, I'll tell you how I work now.
1. I deploy a git repository on the hosting and clone it locally.
2. I add WordPress, all files, except for wp-content, fall under version control.
3. While developing the database is local, then manually update it on the server.
Well, that is, in general, everything is OK, but so far you are working only with the database. Usually the editor uploads content on the production site, and I develop something on the local database. As a result, different versions of the database are obtained, which are not clear how to be friends.
How to merge a database? Ideally, one would like to be able to compare and update only the changed parts of the database. So far, I do not understand in the direction of which technologies to look.

Answer 1

I see two options: migrations and manual synchronization, for migrations you can use phing, it has the migration functionality, only php is needed for its operation. For manual synchronization, I use dbForgeStudio, this tool is great for comparing two databases and being able to synchronize both structure and data.

Answer 2

https://versionpress.net/

Answer 3

https://habrahabr.ru/post/121265/