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.

 

Tags

CoreValueData MigrationData Validation

Share


Recent Articles

CoreValue Among Top 15 Big Data Analytics Companies 2018

December 14, 2018

CoreValue is proud to be included in the Top 15 Big Data Analytics Companies List according to TopDevelopers.co. TopDevelopers.co is a leading directory for mobile app, web and software, and digital marketing service agencies. They analyse businesses and firms to expose the actuality of current business needs and the trends that are prolific in offering […]

CoreValue Among 500 Best Software Companies Worldwide

December 12, 2018

This year CoreValue joins the 2018 Software 500 list along with IBM, Microsoft, Dell, Apple, Oracle, SAP. The list honors a success of the best software companies in the world and demonstrates top service providers. The inclusion in the Software 500 list is a great honour for CoreValue as it gives national and global recognition […]