What I need from the tool is fairly simple, and this is a one-time effort, so maintainability isn't a priority. We are just going to take 14 separate MySQL database instances and need to combine the data into one database. There are some 200 tables involved, so we need something that can ease the pain of letting db rows get assigned a new PK value (most tables have an auto-increment int PK) and having all the FK columns pointing to those PK's pick up the new value.
And since the laws of entropy are still in effect, we only have explicit FK relationships defined -most- of the time. We need to be able to stick our thumb in their and get it to update FK columns that aren't explicitly marked as such.
Something that could automagically walk the table dependencies for the FK relationships that do exist would be nice too.
Looking at the list of ETL tools on wikipedia, which is helpful, but it's difficult to tell which tools would be overkill.