---
id: "google-database-migration-service"
type: "component"
kind: "change-data-capture"
provider: "gcp"
category: "messaging"
aliases: "DMS"
docs: "https://cloud.google.com/database-migration/docs/mysql/faq"
url: "https://localhost:3000/catalogue/components/google-database-migration-service"
---

# Database Migration Service

Migration job doing an initial dump then ongoing replication into Cloud SQL or AlloyDB.

| | |
|---|---|
| Provider | [gcp](https://localhost:3000/catalogue?provider=gcp) |
| Kind | [Change data capture](https://localhost:3000/catalogue/kinds/change-data-capture) |
| Category | Messaging |
| Official docs | [https://cloud.google.com/database-migration/docs/mysql/faq](https://cloud.google.com/database-migration/docs/mysql/faq) |
| Also known as | DMS |

## Properties

| property | type | values | required | kind default | this component |
|---|---|---|---|---|---|
| `connectivityMethod` | enum | `ip-allowlist`, `reverse-ssh-tunnel`, `private-connectivity` | no | — | inherited |
| `managed` | boolean | — | no | false | **true** |
| `migrationType` | enum | `one-time`, `continuous` | no | "continuous" | inherited |
| `mode` | enum | `log-based`, `trigger`, `polling` | no | "log-based" | inherited |
| `ordered` | boolean | — | no | true | inherited |
| `schemaEvolution` | boolean | — | no | false | **true** |
| `sourceConnectionEncrypted` | boolean | — | no | false | inherited |

Bold values are the ones this component pins.

## Rules that apply · 0

No rule selects this kind or its category.

## Other products of the same kind · 14

- [Data Transmission Service](https://localhost:3000/catalogue/components/alibaba-dts.md) `alibaba-dts` — alibabacloud
- [AWS DMS](https://localhost:3000/catalogue/components/aws-dms.md) `aws-dms` — aws
- [Amazon DynamoDB Streams](https://localhost:3000/catalogue/components/aws-dynamodb-streams.md) `aws-dynamodb-streams` — aws
- [Brooklin](https://localhost:3000/catalogue/components/brooklin.md) `brooklin` — default
- [Alibaba Canal](https://localhost:3000/catalogue/components/canal.md) `canal` — default
- [Generic change data capture](https://localhost:3000/catalogue/components/change-data-capture.md) `change-data-capture` — default
- [Debezium](https://localhost:3000/catalogue/components/debezium.md) `debezium` — default
- [Estuary Flow](https://localhost:3000/catalogue/components/estuary.md) `estuary` — default
- [Apache Kafka Connect](https://localhost:3000/catalogue/components/kafka-connect.md) `kafka-connect` — default
- [Maxwell](https://localhost:3000/catalogue/components/maxwell.md) `maxwell` — default
- [Striim](https://localhost:3000/catalogue/components/striim.md) `striim` — default
- [Datastream](https://localhost:3000/catalogue/components/google-datastream.md) `google-datastream` — gcp
- [IBM Data Replication](https://localhost:3000/catalogue/components/ibm-data-replication.md) `ibm-data-replication` — ibm
- [OCI GoldenGate](https://localhost:3000/catalogue/components/oci-goldengate.md) `oci-goldengate` — oci

## Use it in a design

```yaml
nodes:
  - { id: "google-database-migration-service", component: "google-database-migration-service" }
```

## Source (`component` YAML, verbatim)

```yaml
# yaml-language-server: $schema=../../schema/component.schema.json
# Database Migration Service migration job: managed initial dump followed by ongoing
# replication into Cloud SQL or AlloyDB. The MySQL FAQ states DML and DDL changes are applied
# during a continuous migration and that, over an IP allowlist, the source connection is not
# encrypted unless SSL is enabled on the source database.
schemaVersion: "1"
type: "component"
id: "google-database-migration-service"
kind: "change-data-capture"
provider: "gcp"
docs: "https://cloud.google.com/database-migration/docs/mysql/faq"
aliases: ["DMS"]
defaults:
  schemaEvolution: true
  managed: true
properties:
  migrationType:
    type: "enum"
    values: ["one-time", "continuous"]
    default: "continuous"
  connectivityMethod:
    type: "enum"
    values: ["ip-allowlist", "reverse-ssh-tunnel", "private-connectivity"]
  sourceConnectionEncrypted:
    type: "boolean"
    default: false
```

Human page: https://localhost:3000/catalogue/components/google-database-migration-service