Spanner migration tool

Spanner migration tool (SMT) is a stand-alone open source tool for Cloud Spanner evaluation and migration.

Learn More View it on GitHub

Spanner migration tool is a stand-alone open source tool for Cloud Spanner evaluation and migration, using data from an existing PostgreSQL or MySQL database. The tool ingests schema and data from either a pg_dump/mysqldump file or directly from the source database, and supports both schema and data migration.

What does Spanner migration tool do?

Schema migrations

Spanner migration tool is designed to simplify Spanner evaluation and migration. It automatically builds a Spanner schema from the schema of the source database. This schema can be customized using the web based schema assistant UI. Expect that you’ll need to tweak and enhance what Spanner migration tool produces.

Data migrations

Spanner migration tool can be used to do small scale on-prem POC migrations to get a feel of Spanner.

  • POC Migration - This mode is useful to get up and running quickly to get a feel of what migrating to Spanner would look like. This mode of migration uses the local machine’s resources (on which SMT is running) to write data to Spanner. This is an offline migration for migrating moderate-size datasets to Spanner(up to about 100GB). More details about POC migrations are here.

Supported Sources and Targets

  • Schema Migrations: SMT supports schema migrations for MySQL, PostgreSQL and Cassandra.
  • Data Migrations: SMT supports POC migration for MySQL and PostgreSQL databases.

About the project

Contributing

Spanner migration tool is an open-source project and we’d love to accept contributions to it. Details on how to contribute are listed here.

License

Spanner Migration tool is licensed during the Apache 2.0 License.

Spanner migration tool is an officially supported Google product. Please reach out to GCP support to get help.