Is there any alternate solution beside checksum to check the data accuracy after data migration via SSIS with ETL apply? Basically we need to check the destination data are accuracy for a huge database. Thanks. Meng Chew

Hello, Check these link http://msdn.microsoft.com/en-us/library/aa833428(v=vs.80).aspx http://blogs.msdn.com/b/jannemattila/archive/2008/02/13/comparing-two-databases-schema-and-or-data.aspx Thanks http://sqlage.blogspot.com/

Thanks for the info. But due to we had implement ETL in between, so the destination data will changes. Visual studio data comparision seem like not the ideal tool to check the data accuracy. Meng Chew