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.