Compare data upgrade row counts

Important

This content is archived and is not being updated. For the latest documentation, see Microsoft Dynamics 365 product documentation. For the latest release plans, see Dynamics 365 and Microsoft Power Platform release plans.

Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2, Microsoft Dynamics AX 2012 Feature Pack, Microsoft Dynamics AX 2012

The Compare data upgrade row counts task in the Data upgrade checklist checks the data integrity on the Microsoft Dynamics AX 2012 target system following upgrade. Correctly correlated row counts among the source, shadow, and target tables suggest, but do not confirm, that bulk copy and data upgrade finished successfully.

Warning

Row counts are only a preliminary check of data integrity. It is vital to perform more granular checks on data integrity before putting your Microsoft Dynamics AX 2012 system into production.

Compare source and target row counts

The Compare data upgrade row counts form displays related tables as records in a grid. It also provides status figures that report possible problems. At a glance, you can compare table row counts across the upgrade process starting with the source tables, passing to the shadow tables, and ending with the target tables.

Row count is strictly a check on likely success or failure of a table upgrade. When counts fail to match, you should investigate the table involved and the script that processed it. However, even a successful match does not guarantee that the upgrade was successful, and a failed match may not correspond to a problem. To be confident that the upgrade succeeded, you must perform validation tailored to your particular business data.