- Table migration is done by copying the data. In-place
migration is not supported.
- Tables with decomposition rules are currently not supported.
- The External Migrator will change all ‘0000-00-00’ DATE values
to ‘100-01-01’.
- The External Migrator will change all ‘0000-00-00 00:00:00’
DATETIME and TIMESTAMP values to ‘100-01-01 00:00:00’ and ‘1970-01-01
00:00:00’.
- The External Migrator will apply a common character set to all
columns being migrated. This is necessary because Hyperstage for
PostgreSQL requires that all columns within a given database have
the same character set.
- The External Migrator will recalculate Data Pack Nodes and Knowledge
Nodes.
- Tables previously using LOOKUP columns will be migrated to DIMENSION
columns.
- There is no support for Default values within PostgreSQL. Therefore,
this modifier will not be migrated.