Limitations and Notes
- 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.