Is there any standard in choosing the testing database? For example, I have a group of programmers (15-20) and I want to coordinate their unit testing, what is the best way to select the testing database:
1- every developer test his/her module in his own database, and if there is any calling methods we will arrange that.
2- Or have one big database for all developers to test in?
The problem with the second choice is every developer will modify the database in certain way might affect other testing.
The problem with the first choice, that we wonít be able to perform regression testing, we might need a separate database just for regression testing.
Is there any standard for this situation? Have you ever had this situation before? Pls help.
What information will you be keeping in the database? I've done a bit of unit testing but I've never used a database to maintain any input data, procedures, or results. I have used other documentation to maintain unit test procedures, but nothing like what you are proposing.
I would have a group of testers 2-3 possible test one common database. That database should be set-up and look just like the production database, as well. I would probablly have each test do perform different actions. For instance one might test the updating of data, another deletion of data, and the third the adding of data. You might have stored procedures which need to be tested, and relationships which need to be verified. I would just have the different testers focus on different parts of the testing, and just make sure their is enough data so that the tester updating data is not working with the data another tester is deleting.