.TH "GCLOUD_DATABASE\-MIGRATION_MIGRATION\-JOBS_UPDATE" 1



.SH "NAME"
.HP
gcloud database\-migration migration\-jobs update \- update a Database Migration Service migration job



.SH "SYNOPSIS"
.HP
\f5gcloud database\-migration migration\-jobs update\fR (\fIMIGRATION_JOB\fR\ :\ \fB\-\-region\fR=\fIREGION\fR) [\fB\-\-no\-async\fR] [\fB\-\-commit\-id\fR=\fICOMMIT_ID\fR] [\fB\-\-destination\fR=\fIDESTINATION\fR] [\fB\-\-display\-name\fR=\fIDISPLAY_NAME\fR] [\fB\-\-dump\-parallel\-level\fR=\fIDUMP_PARALLEL_LEVEL\fR] [\fB\-\-dump\-type\fR=\fIDUMP_TYPE\fR] [\fB\-\-filter\fR=\fIFILTER\fR] [\fB\-\-source\fR=\fISOURCE\fR] [\fB\-\-type\fR=\fITYPE\fR] [\fB\-\-update\-labels\fR=[\fIKEY\fR=\fIVALUE\fR,...]] [\fB\-\-all\-databases\fR\ |\ \fB\-\-databases\-filter\fR=\fIdatabaseName\fR,[...]] [\fB\-\-clear\-labels\fR\ |\ \fB\-\-remove\-labels\fR=[\fIKEY\fR,...]] [\fB\-\-dump\-flags\fR=[\fIKEY\fR=\fIVALUE\fR,...]\ |\ \fB\-\-dump\-path\fR=\fIDUMP_PATH\fR] [\fB\-\-max\-concurrent\-cdc\-connections\fR=\fIMAX_CONCURRENT_CDC_CONNECTIONS\fR\ \fB\-\-max\-concurrent\-full\-dump\-connections\fR=\fIMAX_CONCURRENT_FULL_DUMP_CONNECTIONS\fR\ \fB\-\-max\-concurrent\-destination\-connections\fR=\fIMAX_CONCURRENT_DESTINATION_CONNECTIONS\fR\ \fB\-\-transaction\-timeout\fR=\fITRANSACTION_TIMEOUT\fR] [\fB\-\-peer\-vpc\fR=\fIPEER_VPC\fR\ |\ \fB\-\-static\-ip\fR\ |\ \fB\-\-vm\fR=\fIVM\fR\ \fB\-\-vm\-ip\fR=\fIVM_IP\fR\ \fB\-\-vm\-port\fR=\fIVM_PORT\fR\ \fB\-\-vpc\fR=\fIVPC\fR] [\fB\-\-sqlserver\-databases\fR=\fIdatabaseName\fR,[...]\ \fB\-\-sqlserver\-diff\-backup\fR\ \fB\-\-sqlserver\-encrypted\-databases\fR=\fISQLSERVER_ENCRYPTED_DATABASES\fR\ \fB\-\-sqlserver\-promote\-when\-ready\fR] [\fIGCLOUD_WIDE_FLAG\ ...\fR]



.SH "DESCRIPTION"

Update a Database Migration Service migration job.
.RS 2m
.IP "\(bu" 2m
Draft migration job: user can update all available flags.
.IP "\(bu" 2m
Any other state can only update flags: \f5\-\-display\-name\fR,
\f5\-\-dump\-path\fR, and connectivity method flags.
.RE
.sp



.SH "EXAMPLES"

To update the source and destination connection profiles of a draft migration
job:

.RS 2m
$ gcloud database\-migration migration\-jobs update my\-migration\-job \e
  \-\-region=us\-central1 \-\-source=new\-src \-\-destination=new\-dest
.RE

To update the display name of a running migration job:

.RS 2m
$ gcloud database\-migration migration\-jobs update my\-migration\-job \e
  \-\-region=us\-central1 \-\-display\-name=new\-name
.RE



.SH "POSITIONAL ARGUMENTS"

.RS 2m
.TP 2m

Migration job resource \- The migration job to update. The arguments in this
group can be used to specify the attributes of this resource. (NOTE) Some
attributes are not given arguments in this group but can be set in other ways.

To set the \f5project\fR attribute:
.RS 2m
.IP "\(em" 2m
provide the argument \f5migration_job\fR on the command line with a fully
specified name;
.IP "\(em" 2m
provide the argument \f5\-\-project\fR on the command line;
.IP "\(em" 2m
set the property \f5core/project\fR.
.RE
.sp

This must be specified.


.RS 2m
.TP 2m
\fIMIGRATION_JOB\fR

ID of the migration_job or fully qualified identifier for the migration_job.

To set the \f5migration_job\fR attribute:
.RS 2m
.IP "\(bu" 2m
provide the argument \f5migration_job\fR on the command line.
.RE
.sp

This positional argument must be specified if any of the other arguments in this
group are specified.

.TP 2m
\fB\-\-region\fR=\fIREGION\fR

The Cloud region for the migration_job.

To set the \f5region\fR attribute:
.RS 2m
.IP "\(bu" 2m
provide the argument \f5migration_job\fR on the command line with a fully
specified name;
.IP "\(bu" 2m
provide the argument \f5\-\-region\fR on the command line.
.RE
.sp


.RE
.RE
.sp

.SH "FLAGS"

.RS 2m
.TP 2m
\fB\-\-no\-async\fR

Waits for the operation in progress to complete before returning.

.TP 2m
\fB\-\-commit\-id\fR=\fICOMMIT_ID\fR

Commit id for the conversion workspace to use for creating the migration job. If
not specified, the latest commit id will be used by default.

.TP 2m

Connection profile resource \- ID of the destination connection profile,
representing the destination database. This represents a Cloud resource. (NOTE)
Some attributes are not given arguments in this group but can be set in other
ways.

To set the \f5project\fR attribute:
.RS 2m
.IP "\(em" 2m
provide the argument \f5\-\-destination\fR on the command line with a fully
specified name;
.IP "\(em" 2m
provide the argument \f5\-\-project\fR on the command line;
.IP "\(em" 2m
set the property \f5core/project\fR.
.RE
.sp

To set the \f5region\fR attribute:
.RS 2m
.IP "\(em" 2m
provide the argument \f5\-\-destination\fR on the command line with a fully
specified name;
.IP "\(em" 2m
provide the argument \f5\-\-region\fR on the command line.
.RE
.sp


.RS 2m
.TP 2m
\fB\-\-destination\fR=\fIDESTINATION\fR

ID of the connection_profile or fully qualified identifier for the
connection_profile.

To set the \f5connection_profile\fR attribute:
.RS 2m
.IP "\(bu" 2m
provide the argument \f5\-\-destination\fR on the command line.
.RE
.sp

.RE
.sp
.TP 2m
\fB\-\-display\-name\fR=\fIDISPLAY_NAME\fR

A user\-friendly name for the migration job. The display name can include
letters, numbers, spaces, and hyphens, and must start with a letter.

.TP 2m
\fB\-\-dump\-parallel\-level\fR=\fIDUMP_PARALLEL_LEVEL\fR

Parallelization level during initial dump of the migration job. If not
specified, will be defaulted to OPTIMAL. \fIDUMP_PARALLEL_LEVEL\fR must be one
of: \fBMIN\fR, \fBOPTIMAL\fR, \fBMAX\fR.

.TP 2m
\fB\-\-dump\-type\fR=\fIDUMP_TYPE\fR

The type of the data dump. Currently applicable for MySQL to MySQL migrations
only. \fIDUMP_TYPE\fR must be one of: \fBLOGICAL\fR, \fBPHYSICAL\fR.

.TP 2m
\fB\-\-filter\fR=\fIFILTER\fR

Filter the entities based on AIP\-160 (https://google.aip.dev/160) standard.
Example: to filter all tables whose name start with "Employee" and are present
under schema "Company", use filter as "Company.Employee\f5*\fR AND type=TABLE"

.TP 2m

Connection profile resource \- ID of the source connection profile, representing
the source database. This represents a Cloud resource. (NOTE) Some attributes
are not given arguments in this group but can be set in other ways.

To set the \f5project\fR attribute:
.RS 2m
.IP "\(em" 2m
provide the argument \f5\-\-source\fR on the command line with a fully specified
name;
.IP "\(em" 2m
provide the argument \f5\-\-project\fR on the command line;
.IP "\(em" 2m
set the property \f5core/project\fR.
.RE
.sp

To set the \f5region\fR attribute:
.RS 2m
.IP "\(em" 2m
provide the argument \f5\-\-source\fR on the command line with a fully specified
name;
.IP "\(em" 2m
provide the argument \f5\-\-region\fR on the command line.
.RE
.sp


.RS 2m
.TP 2m
\fB\-\-source\fR=\fISOURCE\fR

ID of the connection_profile or fully qualified identifier for the
connection_profile.

To set the \f5connection_profile\fR attribute:
.RS 2m
.IP "\(bu" 2m
provide the argument \f5\-\-source\fR on the command line.
.RE
.sp

.RE
.sp
.TP 2m
\fB\-\-type\fR=\fITYPE\fR

Type of the migration job. \fITYPE\fR must be one of: \fBONE_TIME\fR,
\fBCONTINUOUS\fR.

.TP 2m
\fB\-\-update\-labels\fR=[\fIKEY\fR=\fIVALUE\fR,...]

List of label KEY=VALUE pairs to update. If a label exists, its value is
modified. Otherwise, a new label is created.

Keys must start with a lowercase character and contain only hyphens (\f5\-\fR),
underscores (\f5_\fR), lowercase characters, and numbers. Values must contain
only hyphens (\f5\-\fR), underscores (\f5_\fR), lowercase characters, and
numbers.

.TP 2m

The migration job objects config.


.RS 2m
.TP 2m

The migration job objects config for databases.

At most one of these can be specified:


.RS 2m
.TP 2m
\fB\-\-all\-databases\fR

Migrate all databases for the migration job. This flag is used only for Postgres
to AlloyDB migrations and Postgres to Cloud SQL Postgres migrations.

.TP 2m
\fB\-\-databases\-filter\fR=\fIdatabaseName\fR,[...]

A list of databases to be migrated to the destination instance. Provide
databases as a comma separated list. This flag is used only for Postgres to
AlloyDB migrations and Postgres to Cloud SQL Postgres migrations.

.RE
.RE
.sp
.TP 2m

At most one of these can be specified:


.RS 2m
.TP 2m
\fB\-\-clear\-labels\fR

Remove all labels. If \f5\-\-update\-labels\fR is also specified then
\f5\-\-clear\-labels\fR is applied first.

For example, to remove all labels:

.RS 2m
$ gcloud database\-migration migration\-jobs update \-\-clear\-labels
.RE

To remove all existing labels and create two new labels, \f5\fIfoo\fR\fR and
\f5\fIbaz\fR\fR:

.RS 2m
$ gcloud database\-migration migration\-jobs update \-\-clear\-labels \e
  \-\-update\-labels foo=bar,baz=qux
.RE

.TP 2m
\fB\-\-remove\-labels\fR=[\fIKEY\fR,...]

List of label keys to remove. If a label does not exist it is silently ignored.
If \f5\-\-update\-labels\fR is also specified then \f5\-\-update\-labels\fR is
applied first.

.RE
.sp
.TP 2m

At most one of these can be specified:


.RS 2m
.TP 2m
\fB\-\-dump\-flags\fR=[\fIKEY\fR=\fIVALUE\fR,...]

A list of dump flags. An object containing a list of "key": "value" pairs.

.TP 2m
\fB\-\-dump\-path\fR=\fIDUMP_PATH\fR

Path to the dump file in Google Cloud Storage, in the format:
\f5gs://[BUCKET_NAME]/[OBJECT_NAME]\fR.

.RE
.sp
.TP 2m

The heterogeneous migration config. This is used only for Oracle to Cloud SQL
for PostgreSQL and SQL Server to Cloud SQL for PostgreSQL migrations.


.RS 2m
.TP 2m

Configuration for Oracle or SQL Server as a source in a heterogeneous migration.


.RS 2m
.TP 2m
\fB\-\-max\-concurrent\-cdc\-connections\fR=\fIMAX_CONCURRENT_CDC_CONNECTIONS\fR

Maximum number of connections Database Migration Service will open to the source
for CDC phase.

.TP 2m
\fB\-\-max\-concurrent\-full\-dump\-connections\fR=\fIMAX_CONCURRENT_FULL_DUMP_CONNECTIONS\fR

Maximum number of connections Database Migration Service will open to the source
for full dump phase.

.RE
.sp
.TP 2m

Configuration for Postgres as a destination in a heterogeneous migration.


.RS 2m
.TP 2m
\fB\-\-max\-concurrent\-destination\-connections\fR=\fIMAX_CONCURRENT_DESTINATION_CONNECTIONS\fR

Maximum number of concurrent connections Database Migration Service will open to
the destination for data migration.

.TP 2m
\fB\-\-transaction\-timeout\fR=\fITRANSACTION_TIMEOUT\fR

Timeout for data migration transactions.

.RE
.RE
.sp
.TP 2m

The connectivity method used by the migration job. If a connectivity method
isn't specified, then it isn't updated for the migration job.

At most one of these can be specified:


.RS 2m
.TP 2m
\fB\-\-peer\-vpc\fR=\fIPEER_VPC\fR

Name of the VPC network to peer with the Cloud SQL private network.

.TP 2m
\fB\-\-static\-ip\fR

Use the default IP allowlist method. This method creates a public IP that will
be used with the destination Cloud SQL database. The method works by configuring
the source database server to accept connections from the outgoing IP of the
Cloud SQL instance.

.TP 2m

Parameters for the reverse\-SSH tunnel connectivity method.


.RS 2m
.TP 2m
\fB\-\-vm\fR=\fIVM\fR

Name of VM that will host the SSH tunnel bastion.

.TP 2m
\fB\-\-vm\-ip\fR=\fIVM_IP\fR

Bastion Virtual Machine IP.

.TP 2m
\fB\-\-vm\-port\fR=\fIVM_PORT\fR

Forwarding port for the SSH tunnel.

.TP 2m
\fB\-\-vpc\fR=\fIVPC\fR

Name of the VPC network where the VM is hosted.

.RE
.RE
.sp
.TP 2m

At most one of these can be specified:


.RS 2m
.TP 2m

The SQL Server homogeneous migration config. This is used only for SQL Server to
CloudSQL SQL Server migrations.


.RS 2m
.TP 2m
\fB\-\-sqlserver\-databases\fR=\fIdatabaseName\fR,[...]

A list of databases to be migrated to the destination Cloud SQL instance.
Provide databases as a comma separated list. This list should contain all
encrypted and non\-encrypted database names. This flag is used only for SQL
Server to Cloud SQL migrations.

.TP 2m
\fB\-\-sqlserver\-diff\-backup\fR

Enable differential backups. If not specified, differential backups are disabled
by default. Use \-\-sqlserver\-diff\-backup to enable and
\-\-no\-sqlserver\-diff\-backup to disable. This flag is used only for
homogeneous SQL Server to Cloud SQL for SQL Server migrations.

.TP 2m
\fB\-\-sqlserver\-encrypted\-databases\fR=\fISQLSERVER_ENCRYPTED_DATABASES\fR

A JSON/YAML file describing the encryption settings per database for all
encrytped databases. Note: Path to the Certificate (.cer) and Private Key (.pvk)
in Cloud Storage, should be in the form of \f5gs://bucketName/fileName\fR. The
instance must have write permissions to the bucket and read access to the file.
An example of a JSON request: [{ "database": "db1", "encryptionOptions": {
"certPath": "Path to certificate 1", "pvkPath": "Path to certificate private key
1", "pvkPassword": "Private key password 1" } }, { "database": "db2",
"encryptionOptions": { "certPath": "Path to certificate 2", "pvkPath": "Path to
certificate private key 2", "pvkPassword": "Private key password 2" } }]

.RS 2m
This flag accepts "\-" for stdin. This flag is used only for SQL Server to Cloud SQL migrations.
.RE

.TP 2m
\fB\-\-sqlserver\-promote\-when\-ready\fR

Promote the database when it is ready. Use \-\-sqlserver\-promote\-when\-ready
to enable and \-\-no\-sqlserver\-promote\-when\-ready to disable. This flag is
used only for homogeneous SQL Server to Cloud SQL for SQL Server migrations.


.RE
.RE
.RE
.sp

.SH "GCLOUD WIDE FLAGS"

These flags are available to all commands: \-\-access\-token\-file, \-\-account,
\-\-billing\-project, \-\-configuration, \-\-flags\-file, \-\-flatten,
\-\-format, \-\-help, \-\-impersonate\-service\-account, \-\-log\-http,
\-\-project, \-\-quiet, \-\-trace\-token, \-\-user\-output\-enabled,
\-\-verbosity.

Run \fB$ gcloud help\fR for details.



.SH "NOTES"

This variant is also available:

.RS 2m
$ gcloud alpha database\-migration migration\-jobs update
.RE