On 6/4/07 12:31 PM, "paulizaz" <[EMAIL PROTECTED]> wrote:
I have too much data to go through and check if all the data is the same.
This is my problem. Sampling would speed this up, but I need something more
accurate.
All data is important.
Then I think you will also have to write a reverse migration script to convert all the
data back into the old format. I suggest you do this to a different server than the
original server. Then use mysql-table-checksum to verify you got exactly the same data
back (http://sourceforge.net/projects/mysqltoolkit).
I think this is your only option because you must compare the data to the authoritative
copy of it, in the original format, if you want to make sure it is all correct in the
new format.
If you can convert both directions without loss, I think that is as strong a guarantee
as you can get.
Baron
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
