Compare data upgrade row counts [AX 2012]

Updated: July 17, 2011

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.

Caution noteCaution

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.

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.

Announcements: To see known issues and recent fixes, use Issue search in Microsoft Dynamics Lifecycle Services (LCS).