Wherever you are, you can help Ukraine

Act Now! Flag Ukraine

How To Prepare The Testing Data For Database Testing

TestFortExpert by TestFortExpert on 02/13/2012

How To Prepare The Testing Data For Database Testing

One 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.

techniques of preparing test data

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.

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

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 Testfort website.

We use cookies to ensure your best experience. By continuing to browse this site, you accept the use of cookies and "third-party" cookies. For more information or to refuse consent to some cookies, please see our Privacy Policy and Cookie Policy