on-prem oracle to postgreSQL (cloud SQL) Sync

[mgervasi]

Hi, curious if there's a method or recommended practices to be able to replicate or sync an on-prem oracle to a cloudSQL(PostgreSQL) instance? I'm not ready to move my DB over completely as our DB is too integral to our business partners and moving it would be too disruptive. However i'd like to start getting that data to cloud as realtime as possible.

Is there a method i can use to replicate or sync to cloudSQL? or am i better off using pub/sub to publish the oracle data to cloud and consume/load into my postgresql instance?

thx

Mike

[ms4446]

There are several methods and best practices for replicating or syncing an on-premises Oracle database to a Cloud SQL (PostgreSQL) instance in Google Cloud. Here are some options:

Option 1: Google Cloud's Database Migration Service (DMS)

• DMS is a managed service designed primarily for database migration to Cloud SQL. 
• It supports schema conversion and data replication from Oracle to PostgreSQL 

Option 2: Striim

• Striim is a third-party integration tool that facilitates data replication from Oracle to Cloud SQL.
• It provides a user-friendly interface and features like real-time data integration, stream processing, and data transformation.
• While Striim is a comprehensive solution, it may come with a higher cost compared to other options.

Additional Considerations

• Latency: The latency in data replication varies based on the chosen method and configuration. DMS  typically offer lower latency, while Striim  might have slightly higher latency.
• Cost: Costs depend on data scale, complexity, and specific replication requirements. Managed services like DMS might offer cost benefits for simpler setups, while tools like Striim could be more expensive.
• Complexity: Managed services like DMS provide ease of use but less flexibility, whereas Striim offer more control at the cost of increased complexity.

The best replication or syncing method depends on your specific needs, technical expertise, and budget. DMS is suitable for straightforward migrations or initial replications, Striim for comprehensive third-party integration.

[mgervasi]

Thanks tremendously! I was looking into DMS ... I'll have to go through the exercise of sizing to determine cost but i appreciate the low-latency that DMS brings.