...Decide before you do the migration whether you want "timestamp with time zone" or "timestamp without time zone".

I've never had to do that kind of migration before, so I've no comments on your datatype mappings, sorry.