Hi all, I’m hoping someone has solved this before as it’s got me stumped.
One thing which I feel is important to a bug free development cycle is having databases aligned. This would involve an automated process which syncs the databases once a day/hour etc.
One thing which has got me stumped is when development underway. You’re working on the staging site, perhaps extending the database and adding new fields and pages. If you sync the live database to staging you’ll lose all of your changes, if you sync the staging db to live, you potentially lose all of your clients users and comments.
Has anyone achieved a stable workflow with this?
I’d be interested to hear your thoughts.