Schema review workarounds

What to watch out for when migrating data using YugabyteDB Voyager

Review the unsupported features, limitations, and implement suggested workarounds to successfully migrate data from MySQL, Oracle, or PostgreSQL to YugabyteDB.

Unsupported features

Currently, yb-voyager doesn't support the following features:

Feature Description/Alternatives GitHub Issue
ALTER VIEW YugabyteDB does not yet support any schemas containing ALTER VIEW statements. 48
USERS/GRANTS Voyager does not support migrating the USERS and GRANTS from the source database to the target cluster.
CREATE CAST
CREATE SERVER
CREATE ACCESS METHOD
Voyager does not support migrating these object types from the source database to the target cluster.
Unsupported data types Data migration is unsupported for some data types, such as BLOB and XML. For others such as ANY and BFile, both schema and data migration is unsupported. Refer to datatype mapping for the detailed list of data types.
Unsupported PostgreSQL features Yugabyte currently doesn't support the PostgreSQL features listed in PostgreSQL compatibility. If such schema clauses are encountered, Voyager results in an error.

Schema review