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. |
