=== modified file 'modules/db.mssql/db_mssql_migration_grt.py' --- modules/db.mssql/db_mssql_migration_grt.py revid:sergio.delacruz@oracle.com-20121106205238-m0g7q3w5ipm9xpzb +++ modules/db.mssql/db_mssql_migration_grt.py 2012-11-06 21:48:37 +0000 @@ -211,7 +211,9 @@ # string data types: target_datatype = '' if source_datatype in ['VARCHAR', 'NVARCHAR']: - if 0 < source_column.length < 256: + if source_column.length == -1: # VARCHAR(MAX) or NVARCHAR(MAX) + target_datatype = 'LONGTEXT' + elif 0 < source_column.length < 256: target_datatype = 'VARCHAR' else: # MySQL versions > 5.0 can hold up to 65535 chars in a VARCHAR column target_datatype = 'TEXT' if targetCatalog.version.majorNumber < 5 else 'VARCHAR' @@ -260,7 +262,9 @@ target_column.scale = source_column.simpleType.numericScale # binary datatypes: elif source_datatype in ['IMAGE', 'BINARY', 'VARBINARY']: - if 0 <= source_column.length < 256: + if source_column.length == -1: # VARBINARY(MAX) + target_datatype = 'LONGBLOB' + elif 0 <= source_column.length < 256: if source_datatype == 'IMAGE': target_datatype = 'TINYBLOB' else: