This week's challenge: get a MySQL 5.6 SQL export file (33 million records) imported into PostgreSQL v13. 😫
All the 'proper' tools I tried either failed or are still slowly running… the best/fastest option: a Ruby script to convert MySQL INSERTs into PostgreSQL equivalents. 🤷🏻♂️
Conversation
Replying to
It's the first tool I tried (indeed, was part of the documented plan, albeit one that was put together over two years ago). Unfortunately it failed this time around with odd and non-specific errors.