Silverstripe database migration

Silverstripe Version: 3.1.21


Hi, I’m migrating a website from ClearDB Pro60 plan to Microsoft Azure MySQL service. The problem I’m having is that Microsoft Azure MySQL only accept tables with InnoDB as engine and everytime I try to build the project it gives me an error. The build tries to convert the tables to MyISAM and throws an error.

Is there a work around to fix this?