CODEWITHSUNDEEP
phpdatabasegitdeploymentcapistrano
gulty
gulty

Reputation: 1076

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.

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.

Upvotes: 2

Views: 1486

Answers (1)

m4t1t0
m4t1t0

Reputation: 5731

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.

Upvotes: 6

Related Questions