Database deploy with updates

开发者_JS百科Does anybody know how to do smart database update in realtime.

E.g. I have a site with a great database. Suddenly I've made some code changes and database structure and data changes. Is there any standard plan to do it with deploy script or any deploy soft? In realtime without stopping the site?

E.g. switch between two clone databases or smth like that. How do experienced people do that?

Site is written in php, database is MySql.

Thanx!

---

Have you looked at DBdeploy? There's a good article here on managing database deployments using Phing and DBdeploy

---

Red Gate MySQL Compare has a 14-day fully functional trial. It preserves data when doing schema changes. There is also a separate MySQL Data Compare tool.

http://www.red-gate.com/products/sql-development/mysql-compare/