Does anyone have any advice on how to deal with separate databases (local, staging, live) for the same EE site on different servers?
The client changes things on live, but I obviously do any site maintenance or updates from my local > staging versions. I've accidentally overridden the client's changes to the live site before. Any advice on how to avoid this with a module that checks database changes, or even a way to block certain sections of the database from being overridden on import? (like say, any tables dealing with members)
I was looking at Site Manager on github but it is currently in Alpha, so unsure when it can actually be used in production. I have Zenbu installed to check entry edit dates, but no idea how to check for changes elsewhere.