Hyperstage MySQL to PostgreSQL Migrator (“External Migrator”)
The Hyperstage External Migrator allows for migration
of Hyperstage MySQL data to Hyperstage for PostgreSQL. The current
version of the utility works under the following basic assumptions
and conditions.
Assumptions and Conditions
Migrates data from version 4 (latest Hyperstage MySQL) to
data version 5 (latest PostgreSQL version).
Destination data directories must be created for PostgreSQL.
Migration of text types is supported under the following conditions
(all conditions must be satisfied):
If UTF-8 is a charset
in all text columns and no other charset is used.
If binary collations used.
If max text length from a column does not exceed 16K.
Both PostgreSQL and the MySQL instances must be offline.
Columns of time types must not contain 0 (zeros).
Specific data types will require more space.
After the
conversion to PostgreSQL, VARCHAR(n) types will require more than
64KB for a single value. Hyperstage for MySQL using UTF-8 may have
to up 3 bytes whereas Hyperstage for PostgreSQL uses up to 4 bytes.
The maximum value for n is 16K characters.