AlloyDB as destination for Datastream

[michaljemala]

At the time being Datastream only supports BigQuery and GCS to sync data into. We would like to be be able to sync data from Cloud SQL for Postgres to either another Cloud SQL for Postgres instance or even better to the AlloyDB. Any plans to enable these destinations in Datastream?

Thanks & Regard

-Michal

[ms4446 · Accepted solution]

Cloud SQL for Postgres and AlloyDB as both a source and target with DataStreams is on the Product Roadmap. However, the Recommendation today to sync data across Postgres environments is to use either Native logical replication or the pglogical extension.

See the following link for more details: 

https://cloud.google.com/sql/docs/postgres/replication#logical_replication 

[michaljemala]

Thanks for the reply. I know estimations are tough, but any chance to get some timeline on when this would be available in Datastream?

[ms4446]

Unfortunately, We don't have any dates we can share at this time. Best to go the replication route  as its fully supported.

[VishalBulbule]

Hello @michaljemala 

For this operation you can use Data Migration Service with Continuous Job type as shown in below screenshot.

[ms4446]

Just clarify DMS does use logical replication for the purpose of migration. It's not recommended to leave this setup running indefinitely.