How do you make changes in your development site and transfer changes to the live site (assuming you try out things in a dev-environment first)
Especially the database part of it - like config-changes, new tables etc..
While you could start off with transfering database and files from LIVE->DEV, make changes and transfer back DEV->LIVE, you would then miss all user-created-content (postings, new registrations...) during the time you develop, which can be hours, days at least.
So, you would need to "selectively" overwrite tables when syncing DEV->LIVE...
only overwriting/inserting tables/records with config-entries
Which poses the question: Is there a database structural diagram available, which shows dependencies of the user-content-tables..?
(So you could exclude these tables from overwriting)
I hope this question makes sense...?
Is there a better way..?