(Please watch the video at the end of the post for better understanding.)

Introduction

After the migration of data from a legacy system to a new database system, the challenge is to ensure that the data is accurate in the new system.

Our In-house Test Platform compares the source and target data to check the errors after migration and generates reports for the same. 

These reports give us valuable insights as below -

Comparison Summary


Mismatches



Insights from the Report

Following observations can be made by looking at the data -

•Empty / Blank fields

•Incorrect data due to column size


Additionally, our Test Platform can also draw the following insights -

•Duplicated values

•Filtered data etc.

•Incorrect data due to different column data types.