I have the following scenario: I’m using Local to develop, but my colleague is simply using the WPEngine site to add his changes. If I do a “push” of my newest changes, will that overwrite what he’s been doing? We aren’t editing the same pages/posts.
So I was curious if the push mechanism for the database is a “replace entirely the remote with the local” type of situation? Or is it somewhat intelligent about it?
Hi @ctataryn! Great questions here. Local can overwrite the work done by your coworker, so you should tread a little carefully. There are some details on WPE’s documentation about pushing only specific files or modified files.
Since WPE has Staging and Development environments, if you’re worried about losing any work you could copy Production into one of those, and then push there to see if things worked as you intended or not. As always, take frequent backups throughout 
@Nick-B Thanks for the info. I see from the documentation that it’s an outright replacement:
Correct @ctataryn! Apologies for not answering your specific database question there. On a re-read I think I was just focused on your first paragraph and thinking of general changes. Always a good idea to tread carefully when including the DB as that will overwrite the current and as mentioned, make sure to create a fresh backup before doing any updates.