MySQL Forums
Forum List  »  Microsoft SQL Server

Re: Migrate MSSQL Database (10+GB database size) to MySQL community
Posted by: Shamshad Ali
Date: July 22, 2022 12:24AM

I'm getting following error while doing Migration from MSSQL to MySQL using WorkBench ...

1) Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs.
SQL Error: 1118

2) The used storage engine can't index column 'Comments'.
SQL Error: 1167

Out of 47 Tables, 3 tables got warnings in "Create Target Results" step during migration. These 3 tables are Master Tables. The INSERT table script fails due to which billions of transaction rows fails to INSERT rows in TRANSACTION TABLES. After migration wizard completed, when compared SOURCE table rows with TARGET tables, we found difference.

I have already gone through the links you shared. These are basic details with test data, we have LIVE scenario. Indeed, there are design and development and much of testing efforts required. Complete Migration is not possible in one go. We have applications and scenarios behind these databases and it requires almost 65% of R&D time for migration.

An expert guidance is highly appreciated.

Options: ReplyQuote




Sorry, only registered users may post in this forum.

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.