The datamigration1 command-line interface (CLI) allows to use most features of the Google Database Migration Service service from the comfort of your terminal.

By default all output is printed to standard out, but flags can be set to direct it into a file independent of your shell's capabilities. Errors will be printed to standard error, and cause the program's exit code to be non-zero.

If data-structures are requested, these will be returned as pretty-printed JSON, to be useful as input to other tools.

Everything else about the Database Migration Service API can be found at the official documentation site.

Installation and Source Code

Install the command-line interface with cargo using:

cargo install google-datamigration1-cli

Find the source code on github.

Usage

This documentation was generated from the Database Migration Service API at revision 20240621. The CLI is at version 6.0.0.

datamigration1 [options]
        projects
                locations-connection-profiles-create <parent> (-r <kv>)... [-p <v>]... [-o <out>]
                locations-connection-profiles-delete <name> [-p <v>]... [-o <out>]
                locations-connection-profiles-get <name> [-p <v>]... [-o <out>]
                locations-connection-profiles-get-iam-policy <resource> [-p <v>]... [-o <out>]
                locations-connection-profiles-list <parent> [-p <v>]... [-o <out>]
                locations-connection-profiles-patch <name> (-r <kv>)... [-p <v>]... [-o <out>]
                locations-connection-profiles-set-iam-policy <resource> (-r <kv>)... [-p <v>]... [-o <out>]
                locations-connection-profiles-test-iam-permissions <resource> (-r <kv>)... [-p <v>]... [-o <out>]
                locations-conversion-workspaces-apply <name> (-r <kv>)... [-p <v>]... [-o <out>]
                locations-conversion-workspaces-commit <name> (-r <kv>)... [-p <v>]... [-o <out>]
                locations-conversion-workspaces-convert <name> (-r <kv>)... [-p <v>]... [-o <out>]
                locations-conversion-workspaces-create <parent> (-r <kv>)... [-p <v>]... [-o <out>]
                locations-conversion-workspaces-delete <name> [-p <v>]... [-o <out>]
                locations-conversion-workspaces-describe-conversion-workspace-revisions <conversion-workspace> [-p <v>]... [-o <out>]
                locations-conversion-workspaces-describe-database-entities <conversion-workspace> [-p <v>]... [-o <out>]
                locations-conversion-workspaces-get <name> [-p <v>]... [-o <out>]
                locations-conversion-workspaces-get-iam-policy <resource> [-p <v>]... [-o <out>]
                locations-conversion-workspaces-list <parent> [-p <v>]... [-o <out>]
                locations-conversion-workspaces-mapping-rules-create <parent> (-r <kv>)... [-p <v>]... [-o <out>]
                locations-conversion-workspaces-mapping-rules-delete <name> [-p <v>]... [-o <out>]
                locations-conversion-workspaces-mapping-rules-get <name> [-p <v>]... [-o <out>]
                locations-conversion-workspaces-mapping-rules-import <parent> (-r <kv>)... [-p <v>]... [-o <out>]
                locations-conversion-workspaces-mapping-rules-list <parent> [-p <v>]... [-o <out>]
                locations-conversion-workspaces-patch <name> (-r <kv>)... [-p <v>]... [-o <out>]
                locations-conversion-workspaces-rollback <name> (-r <kv>)... [-p <v>]... [-o <out>]
                locations-conversion-workspaces-search-background-jobs <conversion-workspace> [-p <v>]... [-o <out>]
                locations-conversion-workspaces-seed <name> (-r <kv>)... [-p <v>]... [-o <out>]
                locations-conversion-workspaces-set-iam-policy <resource> (-r <kv>)... [-p <v>]... [-o <out>]
                locations-conversion-workspaces-test-iam-permissions <resource> (-r <kv>)... [-p <v>]... [-o <out>]
                locations-fetch-static-ips <name> [-p <v>]... [-o <out>]
                locations-get <name> [-p <v>]... [-o <out>]
                locations-list <name> [-p <v>]... [-o <out>]
                locations-migration-jobs-create <parent> (-r <kv>)... [-p <v>]... [-o <out>]
                locations-migration-jobs-delete <name> [-p <v>]... [-o <out>]
                locations-migration-jobs-demote-destination <name> (-r <kv>)... [-p <v>]... [-o <out>]
                locations-migration-jobs-generate-ssh-script <migration-job> (-r <kv>)... [-p <v>]... [-o <out>]
                locations-migration-jobs-generate-tcp-proxy-script <migration-job> (-r <kv>)... [-p <v>]... [-o <out>]
                locations-migration-jobs-get <name> [-p <v>]... [-o <out>]
                locations-migration-jobs-get-iam-policy <resource> [-p <v>]... [-o <out>]
                locations-migration-jobs-list <parent> [-p <v>]... [-o <out>]
                locations-migration-jobs-patch <name> (-r <kv>)... [-p <v>]... [-o <out>]
                locations-migration-jobs-promote <name> (-r <kv>)... [-p <v>]... [-o <out>]
                locations-migration-jobs-restart <name> (-r <kv>)... [-p <v>]... [-o <out>]
                locations-migration-jobs-resume <name> (-r <kv>)... [-p <v>]... [-o <out>]
                locations-migration-jobs-set-iam-policy <resource> (-r <kv>)... [-p <v>]... [-o <out>]
                locations-migration-jobs-start <name> (-r <kv>)... [-p <v>]... [-o <out>]
                locations-migration-jobs-stop <name> (-r <kv>)... [-p <v>]... [-o <out>]
                locations-migration-jobs-test-iam-permissions <resource> (-r <kv>)... [-p <v>]... [-o <out>]
                locations-migration-jobs-verify <name> (-r <kv>)... [-p <v>]... [-o <out>]
                locations-operations-cancel <name> (-r <kv>)... [-p <v>]... [-o <out>]
                locations-operations-delete <name> [-p <v>]... [-o <out>]
                locations-operations-get <name> [-p <v>]... [-o <out>]
                locations-operations-list <name> [-p <v>]... [-o <out>]
                locations-private-connections-create <parent> (-r <kv>)... [-p <v>]... [-o <out>]
                locations-private-connections-delete <name> [-p <v>]... [-o <out>]
                locations-private-connections-get <name> [-p <v>]... [-o <out>]
                locations-private-connections-get-iam-policy <resource> [-p <v>]... [-o <out>]
                locations-private-connections-list <parent> [-p <v>]... [-o <out>]
                locations-private-connections-set-iam-policy <resource> (-r <kv>)... [-p <v>]... [-o <out>]
                locations-private-connections-test-iam-permissions <resource> (-r <kv>)... [-p <v>]... [-o <out>]
  datamigration1 --help

Configuration:
  [--scope <url>]...
            Specify the authentication a method should be executed in. Each scope
            requires the user to grant this application permission to use it.
            If unset, it defaults to the shortest scope url for a particular method.
  --config-dir <folder>
            A directory into which we will store our persistent data. Defaults to
            a user-writable directory that we will create during the first invocation.
            [default: ~/.google-service-cli]

Configuration

The program will store all persistent data in the ~/.google-service-cli directory in JSON files prefixed with datamigration1-. You can change the directory used to store configuration with the --config-dir flag on a per-invocation basis.

More information about the various kinds of persistent data are given in the following paragraphs.

Authentication

Most APIs require a user to authenticate any request. If this is the case, the scope determines the set of permissions granted. The granularity of these is usually no more than read-only or full-access.

If not set, the system will automatically select the smallest feasible scope, e.g. when invoking a method that is read-only, it will ask only for a read-only scope. You may use the --scope flag to specify a scope directly. All applicable scopes are documented in the respective method's CLI documentation.

The first time a scope is used, the user is asked for permission. Follow the instructions given by the CLI to grant permissions, or to decline.

If a scope was authenticated by the user, the respective information will be stored as JSON in the configuration directory, e.g. ~/.google-service-cli/datamigration1-token-<scope-hash>.json. No manual management of these tokens is necessary.

To revoke granted authentication, please refer to the official documentation.

Application Secrets

In order to allow any application to use Google services, it will need to be registered using the Google Developer Console. APIs the application may use are then enabled for it one by one. Most APIs can be used for free and have a daily quota.

To allow more comfortable usage of the CLI without forcing anyone to register an own application, the CLI comes with a default application secret that is configured accordingly. This also means that heavy usage all around the world may deplete the daily quota.

You can workaround this limitation by putting your own secrets file at this location: ~/.google-service-cli/datamigration1-secret.json, assuming that the required datamigration API was enabled for it. Such a secret file can be downloaded in the Google Developer Console at APIs & auth -> Credentials -> Download JSON and used as is.

Learn more about how to setup Google projects and enable APIs using the official documentation.

Debugging

Even though the CLI does its best to provide usable error messages, sometimes it might be desirable to know what exactly led to a particular issue. This is done by allowing all client-server communication to be output to standard error as-is.

The --debug flag will print errors using the Debug representation to standard error.

You may consider redirecting standard error into a file for ease of use, e.g. datamigration1 --debug <resource> <method> [options] 2>debug.txt.