Re: Migrate MSSQL Database (10+GB database size) to MySQL community

[Peter Brawley]

> I can't share the DDL and data as it is not allowed

?! There are three ways to get help, (i) enterprise edition, (ii) hire a developer, (iii) a public forum like this. At the very least, surely you can post DDL with renamed tables & columns.

> error `MyDB`.`tbl_ACCOUNTS_HST`:Type mismatch fetching field 3 (should be string, was MYSQL_TYPE_LONG) error `

> error `MyDB`.`tbl_TRANSACTIONS`:Inserting Data: Data too long for column 'Transaction_description'

That you should be able to correct, yourself

Without DDL I cannot help you with that.

> Found record bigger than max_allowed_packet error

Read about max_allowed_packet, adjust the value upward, restart the server, retry