In 2013 I was migrating a mysql database to postgres, for a tech demo as I'm a bit of a fan of postgres.
What followed was pgloader spitting out millions of errors, I assumed I had used the tool wrong or it was broken; but the more I looked at it the more I realised that we'd been suffering silent data corruption for years- and postgresql wouldn't validate the invalid data.
Oh, and the datetime thing, that was annoying. Fun things used to happen with mysql when you had a NOT NULL constraint but didn't specify a default.
In 2013 I was migrating a mysql database to postgres, for a tech demo as I'm a bit of a fan of postgres.
What followed was pgloader spitting out millions of errors, I assumed I had used the tool wrong or it was broken; but the more I looked at it the more I realised that we'd been suffering silent data corruption for years- and postgresql wouldn't validate the invalid data.
Oh, and the datetime thing, that was annoying. Fun things used to happen with mysql when you had a NOT NULL constraint but didn't specify a default.