SQL Server to MySQL

[Robin Oaks]

Migrating a SQL Server 2008 R2 database to MySQL Server 5.5 using Workbench 5.2 throws create table error for varchar(max) data types.

The CREATE TABLE script generated for the SQL Server fields of type varchar(MAX) are defined as just varchar with no size like varchar(255). These should be TEXT or one of its variation and when I edit to TEXT, it works. Is there a setting or configuration somewhere that I can set to persist this correction?



Edited 1 time(s). Last edit at 01/10/2013 01:59PM by Robin Oaks.