- NAME
-
- gcloud alpha spanner migrate schema-and-data - migrate data from a source database to Cloud Spanner given a schema
- SYNOPSIS
-
-
gcloud alpha spanner migrate schema-and-data
--source
=SOURCE
--target-profile
=TARGET_PROFILE
[--dry-run
] [--log-level
=LOG_LEVEL
] [--prefix
=PREFIX
] [--skip-foreign-keys
] [--source-profile
=SOURCE_PROFILE
] [--target
=TARGET
] [--write-limit
=WRITE_LIMIT
] [GCLOUD_WIDE_FLAG …
]
-
- DESCRIPTION
-
(ALPHA)
Migrate data from a source database to Cloud Spanner given a schema. - EXAMPLES
-
To generate schema and copy data to Cloud Spanner from a source database:
gcloud alpha spanner migrate schema-and-data --source=postgresql < ~/cart.pg_dump --target-profile='instance=spanner-instance'
- REQUIRED FLAGS
-
--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)".
- OPTIONAL FLAGS
-
--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.
--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).
- 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
$ gcloud help
for details. - NOTES
- This command is currently in alpha and might change without notice. If this command fails with API permission errors despite specifying the correct project, you might be trying to access an API with an invitation-only early access allowlist.
Except as otherwise noted, the content of this page is licensed under the Creative Commons Attribution 4.0 License, and code samples are licensed under the Apache 2.0 License. For details, see the Google Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.
Last updated 2024-02-06 UTC.
[{
"type": "thumb-down",
"id": "hardToUnderstand",
"label":"Hard to understand"
},{
"type": "thumb-down",
"id": "incorrectInformationOrSampleCode",
"label":"Incorrect information or sample code"
},{
"type": "thumb-down",
"id": "missingTheInformationSamplesINeed",
"label":"Missing the information/samples I need"
},{
"type": "thumb-down",
"id": "otherDown",
"label":"Other"
}]
[{
"type": "thumb-up",
"id": "easyToUnderstand",
"label":"Easy to understand"
},{
"type": "thumb-up",
"id": "solvedMyProblem",
"label":"Solved my problem"
},{
"type": "thumb-up",
"id": "otherUp",
"label":"Other"
}]