Overview

Migrate your database using YugabyteDB Voyager

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.

Voyager Architecture

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.
  • 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 of Oracle databases with fall-forward and fall-back. TP
  • Live migration of PostgreSQL databases with fall-forward. TP

Migration types

You can perform migration by choosing one of the following options:

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 and Live 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 shows the target database support for each migration type.

Migration type Supported YugabyteDB Versions Supported products
Offline v2.16
v2.18
v2.19
YugabyteDB
YugabyteDB Anywhere
YugabyteDB Managed
Live v2.16
v2.18
v2.19
YugabyteDB
YugabyteDB Anywhere
YugabyteDB Managed
Live with fall-forward
Live with fall-back
v2.18.2.x YugabyteDB
YugabyteDB Anywhere