View Issue Details

IDProjectCategoryView StatusLast Update
0004298SymmetricDSBugpublic2020-03-04 13:09 Assigned To 
Status newResolutionopen 
Product Version3.11.5 
Summary0004298: Sycing schemas from MSSQL with column type CHAR(400) to MySQL fails
DescriptionMSSQL has max lenght of CHAR type = 8000, but MySQL/MariaDB has max lenght of CHAR type = 255.
I would suggest mapping on MySQL side to VARCHAR(X)

MSSQL has column CHAR(X)
MySQL mapps to column VARCHAR(X)

If possible this conversion can be done only if X (length) exceeds 255.
Steps To ReproduceCreate MSSQL table with column of type CHAR(400) and perform initial load/schame sync to MySQL database


There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2020-03-04 11:52 New Issue
2020-03-04 13:08 elong Project SymmetricDS Pro => SymmetricDS
2020-03-04 13:09 elong Tag Attached: ddl/schema