gcloud alpha spanner migrate schema-and-data

gcloud alpha spanner migrate schema-and-data - migrate data from a source database to Cloud Spanner given a schema

gcloud alpha spanner migrate schema-and-data --source=SOURCE --target-profile=TARGET_PROFILE [--dataflow-template=DATAFLOW_TEMPLATE] [--dry-run] [--log-level=LOG_LEVEL] [--prefix=PREFIX] [--project=PROJECT] [--skip-foreign-keys] [--source-profile=SOURCE_PROFILE] [--target=TARGET] [--write-limit=WRITE_LIMIT] [GCLOUD_WIDE_FLAG …]

--source=SOURCE

Flag for specifying source database (e.g., PostgreSQL, MySQL, DynamoDB).

--target-profile=TARGET_PROFILE

Flag for specifying connection profile for target database (e.g., "dialect=postgresql)".

--dataflow-template=DATAFLOW_TEMPLATE

The google cloud storage path of the minimal downtime migration template to use to run the migration job.

--dry-run

Flag for generating DDL and schema conversion report without creating a Cloud Spanner database.

--log-level=LOG_LEVEL

To configure the log level for the execution (INFO, VERBOSE).

--prefix=PREFIX

File prefix for generated files.

--project=PROJECT

The project in which the migration job and its resources will be created.

--skip-foreign-keys

Skip creating foreign keys after data migration is complete.

--source-profile=SOURCE_PROFILE

Flag for specifying connection profile for source database (e.g., "file=<path>,format=dump").

--target=TARGET

Specifies the target database, defaults to Spanner (accepted values: Spanner) (default "Spanner").

--write-limit=WRITE_LIMIT

Number of parallel writers to Cloud Spanner during bulk data migrations (default 40).

Run $ gcloud help for details.