How to version a database

I am heading up a project that has several members and we are developing a
web application. We have the development environment loaded on our
individual machines to allow development even when not connected.

The part I want some suggestions on is keeping the database up to date. We
use MySql installed on our local machines. The best solution I have come up
with so far is to dump the database to a text file before doing a commit,
keep the dump file in Subversion, and restore the database after doing an
update.

This works, but is clumsy and error prone. How do other people handle this
kind of situation? What other options do people use?

Thanks,
    --Will
will@coaching-life.com

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@subversion.tigris.org
For additional commands, e-mail: users-help@subversion.tigris.org
Received on Sun Feb 6 19:30:52 2005