one
Multi-table data validation tool

Abstract:

A multi-table data validation tool is run following migration of data from a source database to a target database. The multi-table data validation tool extracts data from source and target locations into memory, transforms data and masks confidential data as needed, then performs two types of data comparison, including row count and data content comparison. Result files of each comparison are available to the migration team, enabling updates and improvements to the migration tools. The multi-table data validation tool may further be used to extract requested data from either the source database or the target database. The multi-table data validation tool may be dockerized as a container for ease of deployment in different environments.