Migration and Data Validation Testing
December 7, 2018

Migration and Data Validation Testing

In the world of data, the skillful application of migrated data, the data validation testing has taken an important position. Data migration is an integral component of system implementations, upgrades or consolidations. In order to have productive data migration, outcomes thorough validation are fundamental.

Since data accuracy is key in loading data from one source to a target system, we will need our data to be verified and consistent. Data migration testing is vital for:

  • Checking if all required data was transferred.
  • Validation the correct values in the destination tables.
  • Verification that there is no data loss.

Here are 8 steps to follow in the data migration process.

  1. Define the Scope

Make a list with all the things you need to do, so you have a clear migration test scope.

  1.  Study requirements, Business Rules and Mapping Document  

Make sure that the fields and data types in the original data source and the destination system coincide. Map each type of data, in the legacy system and destination system, in order to prevent data loss. A decent mapping document will represent all of the crucial details of both source and target fields including table, field names, data types and transformation logic, with business rules.

  1. Dependencies and Interactions

Get to know all of the dependencies and interactions with other systems.

  1. Create Test Cases and Queries to Verify the Data

When creating Test Cases, it’s worth to address the following:

Data Completeness with record count verification (by the way of record count for inserted records or record count for updated records) or comparing source and target data sets.

Data Quality is critical, in order to make sure that the data is correctly loaded into the destination tables/fields, that the application correctly rejects, substitutes default values, corrects, ignores, and reports invalid data.

Data Transformation and Data Integrity are comprised of checking to see if the data transformation is working in accordance to the requirements and business rules, if new tables are created, and if new columns are created with proper data types (as specified in the design), as wells as the referential integrity between tables.

  1. Execute Test Cases
  2. Compare the Results

Compare your data after the migration. For huge data sets you may use the Red Gate, SQL Data Compare. Also you can use any tools like Total Commander, Excel to compare flat files.

Keep in mind that data validation shows that data migration was done with all business rules and mapping, but that does not mean everything works well in the destination environment; that is what next steps are for.

  1. Non-Functional Testing

Non-functional testing includes:

  • Security testing – ensures that no security vulnerabilities are opened up.
  • Performance testing – perform load and stress tests to ensure the system’s stability.
  1. Functional Application Test

At the end, run critical business processes in the destination environment. Often there are still some issues that should be fixed before the end of migration process.

Migrating data is not simply transferring information from one storage to another. It is the complex work of a QA team and it requires skill, expertise, tools, and resources. Next time you need to test migrated data, follow these 8 steps and check every important aspect of the migration.



CoreValueData MigrationData Validation


Recent Articles

Why Consider Enterprise CRM for Your Business.

March 20, 2019 | Sam Senyuk, CTO, Head of R&D
Daryna Hameliak, Sales Operations Analyst, CRM Specialist

At a time of deep uncertainty and tech disruption, businesses are struggling harder than ever to retain customers and keep things under control. We are going to highlight the key points of why a CRM system is one of the most relevant means to do just that. Below, our experts will explain further why an […]

Yuriy Adamchuk Becomes a Member of Lviv IT Cluster Management

March 7, 2019

We are happy to announce that Yuriy Adamchuk, Country Director, Ukraine of CoreValue becomes a member of Lviv IT Cluster Supervisory Board CoreValue joined Lviv IT Cluster in 2016. This is a community of leading information technology companies that, together with local authorities and universities, work on development, support and promotion of the IT industry […]

Contact Us