Overview
YugabyteDB Voyager is a powerful open-source data migration engine that accelerates cloud native adoption by removing barriers to moving applications to the public or private cloud. It helps you migrate databases to YugabyteDB quickly and securely.
You manage the entire lifecycle of a database migration, including cluster preparation for data import, schema migration, and data migration, using the yb-voyager command line interface (CLI).
Features
YugabyteDB Voyager has the following features:
- Free and completely open source.
- Supports widely-used databases for migration and, in most cases, doesn't require changes to the source databases.
- Supports all YugabyteDB products as the target database. The target needs to be running YugabyteDB stable versions 2.14.5.0 and later, and preview versions 2.17.0.0 and later.
- Unified CLI experience for all different source databases.
- Auto-tuneable based on workloads, by analyzing the target cluster capacity; runs parallel jobs by default.
- Progress monitoring, including the expected time for data export and import to complete, using progress bars.
- In case of failures, data import can be resumed.
- Parallelism of data across tables.
- Support for direct data import from CSV or TEXT format files present on local disk or on any cloud storage.
- Live migration with fall-forward is supported for Oracle (Tech Preview).
Migration types
You can perform migration by choosing one of the following options:
- Offline migration - Take your applications offline to perform the migration.
- Live migration [Tech Preview] - Migrate your data while your application is running (currently Oracle only).
- Live migration with fall-forward [Tech Preview] - Add a fall-forward database for your live migration (currently Oracle only).
Source databases
YugabyteDB Voyager supports migrating schema and data from your existing RDBMS, as described in the following table:
Source database type | Migration type | Supported versions and flavors |
---|---|---|
PostgreSQL | Offline | PostgreSQL 9.x - 11.x Amazon Aurora PostgreSQL Amazon RDS for PostgreSQL Cloud SQL for PostgreSQL Azure Database for PostgreSQL |
MySQL | Offline | MySQL 8.x MariaDB Amazon Aurora MySQL Amazon RDS for MySQL Cloud SQL for MySQL |
Oracle | Offline and Live | Oracle 11g - 19c Amazon RDS for Oracle |
Target database
The following table describes the supported target databases based on your migration choice.
Migration type | Supported YugabyteDB Versions | Supported products |
---|---|---|
Offline | Stable 2.14.5.0 or later Preview 2.17.0.0 or later |
YugabyteDB YugabyteDB Anywhere YugabyteDB Managed |
Live | Stable 2.14.5.0 or later Preview 2.17.0.0 or later |
YugabyteDB YugabyteDB Anywhere YugabyteDB Managed |
Live with fall-forward | Stable 2.18.0.0 or later | YugabyteDB YugabyteDB Anywhere |