Synchronizing Mysql Table Schema [on hold]
- by user1122069
I have some difficulty keeping track of my SQL changes in a text file in SVN. One solution that I am aware of is to put the SQL queries in files (1.sql, 2.sql...) and to manually load each file at the proper time. Besides missing commas, the process is too cumbersome when builds become more frequent. I have actually taken to asking a co-worker to send me his SQL changes on Skype and we just apply the changes immediately on our local, development, and production servers (using three PhpMyAdmin tabs).
I have seen several GUI tools mentioned in similar questions on SO, but these are actually more work and less automated than the aforementioned methods.
Is there any standardized process by which this is done in an automated way? I can only guess that large companies build their own mechanisms of keeping track of database schema changes (yet I can't find a word about it - maybe they use files?).
This question was closed as off-topic on Stack Overflow, so I am re-posting it here.
