This doesn't directly answer your question, but you may want to take a look at DBD::Mock. stvn recently posted a meditation on it and it looks quite good. It won't automate the creation of test data, but it will integrate nicely into your test scripts and doesn't require the modification of an actual database.