Troubleshooting Migration Metadata Error During Schema Generation
The NuoDB Migrator contains data type registrations for all standard JDBC types and vendor-specific types for MSSQL, PostgreSQL, MySQL, Oracle, and DB2.
A metadata error during schema generation, “
Unsupported type VARCHAR, type code 12, length 20 on table datatypes1 column c1” for example, indicates that a type needs to be introduced to NuoDB Migrator additionally:
nuodb-migrator schema ... --type.code=12 --type.name=varchar(n)
A SQL type name template
--type.name can contain placeholders, that will be substituted with type specifiers during type name creation, where
p is a placeholder for a precision,
s is a scale and
n is a maximum size.