Tdd - How Many Databases Do You Use For Development?

Hi All,

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?

Regards,

Cass