Bug #81944 | max_allowed_packet error while migrating nvarchar(max) from MS SQL | ||
---|---|---|---|
Submitted: | 21 Jun 2016 8:39 | Modified: | 14 Oct 2016 21:39 |
Reporter: | Andrii Nikitin | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Workbench: Migration | Severity: | S3 (Non-critical) |
Version: | 6.3.7 | OS: | Any |
Assigned to: | CPU Architecture: | Any |
[21 Jun 2016 8:39]
Andrii Nikitin
[21 Jun 2016 8:49]
Andrii Nikitin
Posted by developer: Workaround is to modify column type, e.g.: alter table S alter column Value nvarchar(4000);
[14 Oct 2016 21:39]
Christine Cole
Fixed as of the upcoming MySQL Workbench 6.3.8 release, and here's the changelog entry: When migrating a table with a column of type nvarchar(max) from Microsoft SQL Server, MySQL Workbench found the record to be bigger than the server's max_allowed_packet value and failed to copy the record to the server. Thank you for the bug report.