We just started using EE and are very happy with it, but we are running into a problem.
We got a development/test server and a live server.
The problem is when the site is live and we want to make changes, for example add a plugin.
We add the plugin to the development/test server but then we got 2 different databases,
if we want to push our changes to the live server we can’t replace the live database because then the data inserted by our customer will be overwritten.
And syncing the database is a tricky job for which we need to examine the database really good.
Because of the possibility of the same id’s in the 2 databases referring to 2 different things.
I am curious if other have the same problem and if someone found a solution for this problem.