import data reference

This page describes the usage of the following import commands:

• import data
• import data status

import data

For offline migration, Import the data to the YugabyteDB database.

For live migration (and fall-forward), the command imports the data from the data directory to the target database, and starts ingesting the new changes captured by export data to the target database.

Syntax

yb-voyager import data [ <arguments> ... ]

Arguments

The valid arguments for import data are described in the following table:

Example

yb-voyager import data --export-dir /dir/export-dir \
        --target-db-host 127.0.0.1 \
        --target-db-user ybvoyager \
        --target-db-password 'password' \
        --target-db-name target_db \
        --target-db-schema target_schema \
        --parallel-jobs 12

import data status

For offline migration, get the status report of an ongoing or completed data import operation. The report contains migration status of tables, number of rows or bytes imported, and percentage completion.

For live migration, get the status report of import data. For live migration with fall forward, the report also includes the status of fall forward setup. The report includes the status of tables, the number of rows imported, the total number of changes imported, the number of INSERT, UPDATE, and DELETE events, and the final row count of the target or fall-forward database.

Syntax

Usage: yb-voyager import data status [ <arguments> ... ]

Arguments

The valid arguments for import data status are described in the following table:

Example

yb-voyager import data status --export-dir /dir/export-dir