Is there a tool that allows me to "record" changes to a staging site and later replay them on production?
It is a common usecase for me to set up a staging site (Duplicator is great for that) and implement design changes (including menus, etc.) there for the customer to review. Those changes at some point need to go to production. Works well with files (plugins, themes), but not with the database.
The production system is being used all the time and authors will add content while I'm working on the staging site. Hence I can't simply copy over the whole posts table.
Instead I'd need a solution that records any SQL statement made to selected tables and replays them on production later on. Is there such a solution out there?
Is there a tool that allows me to "record" changes to a staging site and later replay them on production?
It is a common usecase for me to set up a staging site (Duplicator is great for that) and implement design changes (including menus, etc.) there for the customer to review. Those changes at some point need to go to production. Works well with files (plugins, themes), but not with the database.
The production system is being used all the time and authors will add content while I'm working on the staging site. Hence I can't simply copy over the whole posts table.
Instead I'd need a solution that records any SQL statement made to selected tables and replays them on production later on. Is there such a solution out there?
Share Improve this question asked Mar 8, 2019 at 19:48 user153119user153119 1- 2 The short answer here is no. Delicious Brains was working on a solution for this called Mergebot and gave up after dumping time and money into it for 2 years. – mrben522 Commented Mar 12, 2019 at 18:36
1 Answer
Reset to default 0Note: This is more a comment than an answer, but I wanted to format it nicely.
I don't know about recording, but I imagine something like the following in SQL could work.
INSERT INTO DB1.Tbl1 ( id, x, y )
SELECT DB2.Tbl1.id, DB2.Tbl1.x, DB2.Tbl1.y
FROM DB2.Tbl1
ON DUPLICATE KEY
UPDATE x=x, y=y;
Beware, this is completely untested. You have to test it and read up on the documentation yourself.