database testing

How To Prepare The Testing Data For Database Testing

database testingOne of the most important stages of database testing is preparing of the testing data, because a clear test data selection is very important in this process. So it’s time to discuss some techniques of preparing test data. Actually, there are only two of them.
Method 1. Inserting new data
You have to clean the database and then insert all the data as it specified in your test cases. When all the required data has been inserted, you have to start executing the test cases filling “Pass/Fail” columns after comparing expected output with the actual one. It could really sound simple, but it’s not.There are some critical concerns that you have to follow.

  • Database empty instance may not be available.
  • You may find out that inserted test data is insufficient for testing soma cases such as load testing and performance.
  • Data insertion may become a difficult task due to database table dependencies.
  • When you insert limited test data, it may hide some issues, but they could be found by big data set.
  • When inserting data, complex procedures and queries may be required.

The issues, mentioned above are the most important for testing data preparation. But there are some advantages of this method as well:

  • Test cases execution becomes more efficient.
  • Bugs isolation doesn’t require any time as the DB is filled only with data specified in the test cases.
  • Testing and results comparison requires less time.
  • The test process is clutter-free.

Method 2. Sample data subset is chosen from the actual DB data.
This is more feasible and practical method for preparation of the test data. However this technique is not for dummies: here you must have some sound technical skills and knowledge in SQL and DB Schema.
So here you have to copy and then use production data replacing some field values by other dummy values. This is definitely the best data subset for your test data because it is representing the production data. But this method is not feasible all the time because of the data security and some privacy issues.

To request a quote for software testing services visit BugHuntress website.

TestFort Blog

About TestFort Blog

TestFort blog is an official blog of TestFort QA Lab company and is dedicated to various QA and software testing issues.


  1. May 2, 2012 @ 8:01 pm Vishnu

    formatting data is to erase data but if you format it, and then made no cgnhaes, there is possible way to recover them, just go to the nearest data recoverer center, and they could recover yours but if you do any other commands, like formatting again, or copy files on it I HAVE TO TELL YOU, I am very so sorry

Would you like to share your thoughts?

Images are for demo purposes only and are properties of their respective owners.
Old Paper by © 2018