Some features of MYSQL like (ON UPDATE CURRENT_TIMESTAMP) for a column is missing during conversion
On this example column C3 during conversion will loose the ( ON UPDATE CURRENT_TIMESTAMP)
SSMA did not create any trigger for this part of the code either.
MY Sql 5.7
Sql Server 2012
C1 int(11) NOT NULL,
C2 varchar(255) DEFAULT NULL,
C3 timestamp NOT NULL DEFAULT CURRENTTIMESTAMP ON UPDATE CURRENTTIMESTAMP
SSMA at the current behavior dismisses the syntax by not generating any WARNING or ERROR. as the result they are lost altogether and user will not know about such missing elements.
My suggestion: as such code is part of schema and data structure, system should generate ERROR for such lines.
Derek Price commented
Is it documented somewhere that Azure MySQL ignores DEFAULT CURRENT_TIMESTAMP & ON UPDATE CURRENT_TIMESTAMP?