Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I'm migrating ~1TB of data from SS to MySQL. The verification process is multi-stage.

  1. Implement Linked Server in MySQL and run binary_checksum on source tbl (SS) and destination tbl (MySQL)

  2. Assuming the checksums do not match, then implement checksums on each row - e.g. Add column on each destination table with a corresponding MD5 hash of the record values. Then compare the MD5 from source to destination.

Any ideas on how to make this easier, faster, better?

Thanks in advance!

share|improve this question

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.