PHP Database Deployment git/capistrano

I’m working for a company which is using PHP. There are different CMS Systems being used like WordPress or Magento.
We are working with git having our own repository server and we have to deploy to different servers our different customers.

I’ve set up a deploymentscript using capistrano which works fine but the Database Synchronisation is quite tricky.

  • git checkout throws fatal reference is not a tree
  • Connection refused on my git's depot
  • Deploying a Git subdirectory in Capistrano
  • Capistrano: Problem with permissions on deploy
  • SASS files management in Git version control system in Ruby on Rails
  • Capistrano error when using git
  • Imagine the live-database contains user data and I have to create some new features after the site already launched and there are loads of sql data within the database already. I personally work with a dummy database since I don’t need any customer information.

    How are you PHP geeks are deploying your databases? I don’t want to change the contents but only migrate new or modified tables. I’m looking for a complete deployment solution for that. I’m also open for other options besides capistrano if needed. Especially with Magento I had serious problems to keep my database sync..

    Any help is appreciated.

  • Jenkins' homepage loading very slowly
  • Best way to deploy from git
  • My artifact seems to big to be deployed by maven. What can I do?
  • Auto Deploying with Git
  • Automatic deploy on commit
  • Jenkins : how to check out artifact from Nexus and Deploy on Tomcat-
  • One Solution collect form web for “PHP Database Deployment git/capistrano”

    Recently I have discovered this project: http://dbv.vizuina.com/, but I don’t have used it, otherwise Symfony has a similar feature called migrations and it works very well.

    Git Baby is a git and github fan, let's start git clone.