Blog

Migration testing: white box approach

White box testing is the approach based upon logical check of the migration script. With the knowledge about the database source and receiver structure the team of QA engineers test completeness and correctness of the script.
25 February 2014
Functional testing
Migration testing
The article by a1qa
a1qa

White box testing is the approach based upon logical check of the migration script. With the knowledge about the database source and receiver structure the team of QA engineers test completeness and correctness of the script. Still, to start white box migration testing the database should comply with the certain preconditions.

  1. Detailed script description (it should prevent the issues of incorrect data migration or the incompleteness)
  2. Structure of the source and the receiver
  3. Data Migration Mapping (set of migration rules written in any suitable format)

When the testers finally jump start the testing process, they get through the standard points:

  • Check of the number of migrated registries
  • The data are migrated to the appropriate place
  • The data fullness
  • Filling of the obligatory fields
  • The proper source and receiver fields processing
  • Accounting business logic changes

Along with these points of migration script check, testers apply the analysis of the SQL code. The approach covers in details the database structure, used data storage formats, migration requirements, analysis of substances, difference among them and their correct processing. The formats of fields and the migration script transformations are also of great importance.

The white box testing approach requires specified knowledge from a tester, unlike the black box approach.

Still, you rarely meet the applying purely the black box or the white box approach, often the complex approach is used. In the complex approach the QA engineers first check the logic of the migration script (white box approach), then they run functional tests (black box approach) on the application to check the migrated data.

More Posts

black-friday
29 July 2022,
by a1qa
4 min read
Get ready for Black-Friday-to-Cyber-Monday shopping: 5 testing types to include in your QA strategy
What’s your nightmare during Black Friday and Cyber Monday shopping? If it’s a loss of sales, read about the ways to prevent this in the article.
Cybersecurity testing
Functional testing
Localization testing
Performance testing
Usability testing
Mobile app testing
31 May 2022,
by a1qa
4 min read
Mobile app testing guide: win the race with five-star software
Which aspects of mobile apps to test first to produce a really high-quality product? Find the answer to this and other questions related to mobile app testing in the article.
Cybersecurity testing
Functional testing
Mobile app testing
Performance testing
Test automation
Usability testing
31 March 2022,
by a1qa
5 min read
The A to Z guide to functional testing
Get a broad overview of functional testing: reasons to introduce it and 5 main phases for a well-tuned process.
Functional testing
streaming services
30 November 2021,
by a1qa
4 min read
Ho ho ho! QA to enable crash-proof streaming platforms for Holidays season
Isn’t it high time to forget about the Christmas rush and truly enjoy the pre-holidays season? Read the article about how to put peak-load anxiety behind by applying rigorous testing of your streaming solution.
Cybersecurity testing
Functional testing
Performance testing
Usability testing
25 February 2021,
by a1qa
4 min read
9 QA points for delivering high-quality SaaS-based solutions
In the article, we’ve gathered 9 QA factors relying on the SaaS specifics that may help to perform SaaS testing with ease.
Cloud-based testing
Cybersecurity testing
Functional testing
Performance testing
Test automation
16 February 2021,
by a1qa
5 min read
Winning trust: 5 industries that need blockchain testing
Get to know what industries are prone to rapid transformation within blockchain solutions, and how their catch-all testing can help keep leading positions.
Blockchain app testing
Cybersecurity testing
Functional testing
Performance testing
29 January 2021,
by a1qa
4 min read
3 do’s and 3 don’ts in BFSI software testing
Considering BFSI to be a fast-paced industry, how to keep up with such velocity? We’ve prepared 3 do’s and 3 don’ts that help sustain the rush and high software quality.
Functional testing
Mobile app testing
Test automation
30 November 2020,
by a1qa
5 min read
Acumatica: ensuring sound business operations with well-tested ERP system
Internal business activities are advancing, while ERP systems’ usage is growing rapidly. Explore how to ascertain their accurate work through timely applying QA.
Big data testing
Cybersecurity testing
ERP testing
Functional testing
Performance testing
Test automation
13 November 2020,
by a1qa
5 min read
QA for media and entertainment
Read the article to explore why QA is a must for the media and entertainment sector and how to perform software testing effectively.
Functional testing
Mobile app testing
Performance testing
Test automation
Usability testing

Get in touch

Please fill in the required field.
Email address seems invalid.
Please fill in the required field.
We use cookies on our website to improve its functionality and to enhance your user experience. We also use cookies for analytics. If you continue to browse this website, we will assume you agree that we can place cookies on your device. For more details, please read our Privacy and Cookies Policy.