For TDD, fixtures are normally used to restore the db to a specific state.
If you use TDD on your regular development cycle, how many databases do you use for your project?
I would imagine the setup would be something like:
TEST DB - fixtures feed data in
DEVELOPMENT DB - all sorts of fiddling will happen here
LIVE DB - no fiddling, live data
However, this appears to augment the workload quite considerably, even if using DB migration (http://www.yiiframework.com/doc/guide/1.1/en/database.migration).
On your real life scenario, how do you address that?