I've recently been working on a mysql to postgres migration and it's been quite bumpy. I'm going to set aside some time to improve some of the import/export webtools items and wanted to know if anyone else had come across additional annoyances that I can be on the lookout to address. Here are two that I'd like to specifically address.
1. Case sensitive fk integrity check 2. Data write/load order for hierarchy fk integrity (parent*Id -> *Id) I think 1 is generally only an issue when going from a mysql (which seems a bit more relaxed) to a stricter (postgres) database. I'm sure there are settings. I think 2 can be addressed pretty well (of course not 100% fool proof) if the output file is written in the right order. If anyone has some more annoyances that I can keep an eye out for when I go to work on this or any thoughts to add on these two, I would appreciate it. ,Chris
