Sync plugin settings (wp_options table) on multiple environments
How do you guys handle database changes, more specifically the settings (wp_options)?
Im looking for something like, having a JSON file (or migration files bit similar like Laravel) with settings, that I can run after a deployment.
For example once I install WooCommerce I have a list with default settings (presets) I want to use and import at once. But also once I add a new feature or plugin that I can migrate those settings across multiple environments.
Would be cool if that JSON file (or settings file) is environment based. So I can use test payment method settings on local and live settings on production. And just run a command like wp migrate options or something in my deployment script, which sets all the correct settings for that environment.
Is there something like that?
Thanks in advance :)