We're working on a large enteprise app where we're converting the data from MS Access.

The original Access project consisted of a Warehouse DB that took snapshots of data from multiple ERP systems into one DB, massaged the data, and crunched some numbers. Along the way some additional data is generated. Then DB the project 2 reads from project 1 and produces reports.

We are well into the process of converting the data to SQL 2005.

What's the best way to validate the data after conversion. Column names may have changed, and structure changes may have occured as well.

Thanks