We are running a PHP (zend framework) app that creates a database per user (for security/backup/and others reasons).
All these databases have exactly the same structure and that will always be the case. When we deploy new features we’ll need to expand all databases with the new fields/tables.
I’ve read about using dbdeploy for that, but I’m not sure that they support multiple databases at once (without giving in the names one by one). Databases are called user1, user2, user3 and so on.
Are there any good tools that will make this process for us a bit easier and less painful?
We are running phing for automated deployment and found the guide http://www.davedevelopment.co.uk/2008/04/14/how-to-simple-database-migrations-with-phing-and-dbdeploy/ not so useful because they don’t support multiple databases like we have.
Also, windows or mac mysql clients that can do this are possible for us, so we are open for anything
Similar:
- Scalability of Using MySQL as a Key/Value Database I am interested to know the performance impacts of using MySQL as a key-value database vs. say Redis/MongoDB/CouchDB. I have used both Redis and CouchDB...
- Question about multiple databases / web.config files. Sorry in advance if this has been asked/answered before.. I can't seem to find any results from searching. I am creating a website where each customer will...
- Drive space hungry NoSQL’s databases I’ve tested NoSQL databases like CouchDB, MongoDB and Cassandra and observed tendence to absorbing very large amount of drive space relative to inserted key-value pairs....
- Adding multiple content databases to Sharepoint I am trying to create a new web application in Web service. I am using this code to do this. SPWebApplicationBuilder webAppBuilder = new SPWebApplicationBuilder(SPFarm.Local);...
- Asp.net and databases Hi, I am newbie to asp.net and am considering carrying out a project in asp or vb. For my project, I am going to require...
Tags: database changes, deployment, good tools, migrations, mysql databases, new features, phing, php zend, security backup, user3, zend framework