I am wondering what’s the best way to import minor DB changes from local to live server.
We have local dev environment where we are adding new features to the site and once tested push them to life server.
Files are covered by git, so it’s easy part.
Difficult part is that often we change some settings in the database, populate the new tables and redoing it all again on live server is very time consuming.
So last time we took latest dump of the live database, made did using Beyond Compare analyzing what tables were changed by us on local server, and imported only these tables.
It was ok, but there should be better tools for that than Beyond Compare, or better approach.
p.s. Initial database structures are identical, products, IDs.
The changes are minor – like adding new module, and prepopulating needed details on local.