Validate your data migration

Data validation is the process of comparing data from both the source and the destination database tables to ensure they match.

The Data Validation Tool (DVT) is an open source tool that can connect to data stores and perform checks between your source database and Spanner. We recommend using it to perform basic validations as a part of your migration, such as the following:

  • Check that all tables were created and that all schema mappings are correct.
  • Match the total number of rows for each table.
  • Extract random rows to verify consistency.
  • Validate your columns, for example, use count, sum, avg, min, max, or group by.
  • Compare any cyclic redundancy checks or hash functions at the row level.

To perform more specific validations, build custom checks during migration.

Except as otherwise noted, the content of this page is licensed under the Creative Commons Attribution 4.0 License, and code samples are licensed under the Apache 2.0 License. For details, see the Google Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.

Last updated 2025年10月14日 UTC.