Migrate Changes from a Staging Site to Production

Question

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?

Answer 1

Note: 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.