Workflow question: Reconciling database local <-> remote

[eluser]Colin Williams[/eluser]
Don't know if I would even have two instances of the same data. Sounds like a bad idea to start out. I mean, you could host ONE database on its own server (very typical) and have all dev environments use that one, perhaps with limited permissions for each.

Local database probably just needs to pull from the main one, never push (write/modify), which can be done manually or by some scheduled batch process/cron script