The zero length property on text fields in Microsoft Access are translated as constraints to target SQL databases. This can cause major issues when translating data as rows can be omitted from the target database. In the worst extremes, I have seen entire tables without data due to there being several text fields with the constraint attached.
Thanks.
Tool version: SSMA for Access 9.4.23215.1002
OS version: Microsoft Windows NT 10.0.19045.0
Correlation: 06f2e1b6-086c-4c01-98d6-ec72689f2bc3
Ignore Zero Length constraints
Issue Type: Feature Requests
Hi,
The zero length property on text fields in Microsoft Access are translated as constraints to target SQL databases. This can cause major issues when translating data as rows can be omitted from the target database. In the worst extremes, I have seen entire tables without data due to there being several text fields with the constraint attached.
Thanks.
Tool version: SSMA for Access 9.4.23215.1002 OS version: Microsoft Windows NT 10.0.19045.0 Correlation: 06f2e1b6-086c-4c01-98d6-ec72689f2bc3