I am sorry if this has been covered, but I can honestly say I have spent at least 3 solid days trying to come up with a version control solution and my head is about to explode.
I have also skimmed through the subversion book but I am still very confused.
Basically I have a SAAS application that has been growing steadily. Currently its really only 1 developer (me) working on the app, but if the interest in it continues I might have to start hiring.
The application is written in PHP, uses a MySQL database and is hosted on a bog standard LAMP stack.
Currently I have GIT installed on my development machine however my lack of understanding has meant that my commits are irregular and often irrelevant and I am having problems with it not tracking changes to directories.
My main concern is deploying to our production server. Our clients each have their own application folders and their own databases.
Currently when we run an update we have to write a custom update script that:
1.Duplicates clients installation into a backup folder
2.Removes the live installation folder
3.Copies the new updated installation folder
4.Copies the users config files from the backup to the live install
5.Tells the operator to make the changes to the users database using a third party app
6.Cleans up.
It was boring with 5 users, but now we are approaching 50 and its an absolute nightmare.
To make things complicated (and a little more secure) each install folder contains unique database settings which means database schema's can only be updated from within that application.
I have been looking into setting up a gitorious server but thought I would seek some advice on how to proceed before i dig myself any deeper.
Thanks