We have one remote database, but multiple local environments which all have different unique domains eg:
localhost:8888, localhost/work/domain.com
When working with Wordpress, we are looking to use a remote database however as shown above we have different local environments. How can we keep these in sync, without replacing the entire database every time someone makes a change? Due to this we can't use database sync plugins.
Currently the remote database carries through all of our local URL's and thus are incorrect when another person makes posts or pages.
Let me know if I can elaborate more.