When upsizing to Microsoft SQL server you may encounter the following error message with some configurations.
SQL state [HY000]; error code ; Binary logging not possible. Message:Transaction level 'READ-COMMITTED' in InnoDB is not safe for binlog mode'STATEMENT'; nested exception is java.sql.BatchUpdateException: Binary loggingnot possible. Message: Transaction level 'READ-COMMITTED' in InnoDB is notsafe for binlog mode 'STATEMENT
Customers who encounter the above error when using Microsft SQL server may need to run the following SQL command:
SET GLOBAL binlog_format = 'ROW'
Please confirm with your database administrator before making this change.