Setting up Test Data

Methods to Test Data

Database dependent Integration Tests vs Mocking Datasets vs End to End Regression Tests

Extracting XML schema's

Extracting production like data as XML sets to stub out the DB calls

Using the system to insert test data

Finding right level of abstraction

Focus on Test Driven Development

Schema per developer

Branching issue

Be careful

Tools mentioned

Unitils (becoming or already is open source)

DBDeploy

DBUnit

In-Memory Databases (Hypersonic, ExtremeDB, JavaDB)