MySQL schema in source control (SVN)
Posted: Tue Jan 19, 2010 9:46 am
Hi all,
Our team is currently using xamp and localhost development (there is no in-office LAN...yet), and are using SVN for source-control. However, one problem I am running into is that when I create a new table, I have to send the query to other in the team so that their localhost DB can be up to date. One solution is to have a remote DB which everyone connects to, but as everyone try out new code and do tests, it would be cluttered and filled with test data.
I m thinking if it is possible somehow to sync MySQL through SVN somehow. How are changes to a database schema usually propagated from the test DB to the live DB?
Our team is currently using xamp and localhost development (there is no in-office LAN...yet), and are using SVN for source-control. However, one problem I am running into is that when I create a new table, I have to send the query to other in the team so that their localhost DB can be up to date. One solution is to have a remote DB which everyone connects to, but as everyone try out new code and do tests, it would be cluttered and filled with test data.
I m thinking if it is possible somehow to sync MySQL through SVN somehow. How are changes to a database schema usually propagated from the test DB to the live DB?