I don't know if this will help in your case, but I had a few years ago a somewhat similar case: a euro migration of a relatively large database with about 120 or 130 tables having monetary values to be converted to the new currency. My responsibility was to validate the data quality after the migration. What we did is simply to dump the tables (or the relevant fields of the tables) into flat CSV files before and after the migration and then just read the files in parallel to compare the monetary values and check their conversion. This turned out to be more practical and much faster than using database indexes to access the data. But, because of the nature of the migration, we were guaranteed to have the data dumped in the same order into the files, making further processing very easy. This might or might not apply to your case.

---

---

Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!

Titles consisting of a single word are discouraged, and in most cases are disallowed outright.

Read Where should I post X? if you're not absolutely sure you're posting in the right place.

Please read these before you post! —

• How do I compose an effective node title?
• How do I post a question effectively?
• Markup in the Monastery

Posts may use any of the Perl Monks Approved HTML tags:

a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr

You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)

	For:		Use:
	&		&
	<		&lt;
	>		&gt;
	[		&#91;
	]		&#93;

Link using PerlMonks shortcuts! What shortcuts can I use for linking?

See Writeup Formatting Tips and other pages linked from there for more info.