For data migration headaches, we used to keep a bottle of our favorite over-the-counter painkiller handy. And then we found
Jitterbit, which makes short work of moving data from one format to another, even where very large datasets are concerned. The UI is simple, portable "Jitterpaks" encourage sharing mechanisms among users, and a testing tool lets you know immediately whether the current settings for a source, an operation, or a target are valid or invalid. Add it all together, and Jitterbit easily moves ahead of other open source products in the space.
FULL REPORT ...