I was recently asked what tools I used to load a database for test runs and I said in the past I wrote a small class that reads a file (a list of SQL commands) and ran the statements against the database of choice. I've used to create my schema, populate the data, etc. But it's been a few years since I've needed such a beast.

Several people in the audience pointed me at dbunit http://dbunit.sourceforge.net/ and also mentioned the Ant SQL task.

So my questions here are:

1) What do you use to reload data before you run your tests?

2) Is it reasonable to ask the C# crowed to install Java and Ant so they can use dbunit or is there a nice C# equivalent?

Thanks!

Jared
http://jaredrichardson.net