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

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
28 October 2020,
by a1qa
5 min read
eHealth software testing: taking the digital Hippocratic oath
Medicine has broken new ground. However, there’s still no room for errors. Get to know more information about effective testing approach in the health sector. 
Big data testing
Functional testing
Performance testing
Test automation
19 August 2020,
by a1qa
4 min read
Data migration to the cloud: enable robust transition through QA
With cloud computing being a pervasive technology, many companies still face challenges to set well-tuned information transfer. Learn how to avoid possible quality issues and be confident in data safety.
Cloud-based testing
Cybersecurity testing
Migration testing
Performance testing
30 January 2020,
by a1qa
6 min read
The long and the short of fintech apps testing
Highly regulated fintech industry needs particular attention to the apps being developed in the ecosystem. Why QA plays a crucial role and what software testing types to conduct, take a note from our article.
Cybersecurity testing
Functional testing
Performance testing
Test automation
22 October 2019,
by a1qa
4 min read
Digging a little deeper into efficient CRM testing
Have a closer look at the CRM testing issues that will help streamline business processes and boost productivity.
CRM testing
Cybersecurity testing
Functional testing
Performance testing
Test automation

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.