Let's say you are building a new theme on a staging site.
While you were building, the production database has changed due to new user registrations/orders.
So now the question becomes how do you upload a new theme together with all the theme database options to a production site without disrupting anything else.
I know you can use something like WP Migrate DB Pro to only push certain tables, but even then which tables to push.
I'm just curious how do people maintain a synced database between a production, staging, and localhost site?
Thank you in advance for any guidance!