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

A SQL type name template 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.