MySQL Forums
Forum List  »  Microsoft SQL Server

Re: Migrate MSSQL Database (10+GB database size) to MySQL community
Posted by: Peter Brawley
Date: July 22, 2022 08:39AM

> 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

Options: ReplyQuote

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.