Yes, you can migrate directly from Oracle to AlloyDB using DMS (Currently in Public Preview). This feature is available and supports a streamlined process for migrating data, schema, and converting complex PL/SQL code to PostgreSQL-compatible SQL.
Key points about using DMS for Oracle to AlloyDB migrations include:
-
Reliable and Complete: DMS leverages native PostgreSQL replication capabilities, ensuring maximum security, fidelity, and reliability in the migration process.
-
Minimal Downtime: The service continuously replicates database changes from Oracle to AlloyDB, allowing for a cutover at a convenient time, thereby minimizing downtime and disruption.
-
Serverless Migration: DMS is a serverless solution, eliminating the need for maintaining or provisioning migration-specific resources. It auto-scales with your data, simplifying the migration process.
-
Schema and Code Conversion: DMS handles the conversion of schema and PL/SQL code to PostgreSQL-compatible SQL as part of the migration.
-
Continuous Replication: The service starts with an initial snapshot of the Oracle database and then replicates ongoing changes in real-time.
-
Ease of Use: The migration process is straightforward, involving the creation of a source connection profile, defining connectivity, and initiating the migration job.
LinkedIn
Twitter
