Stay organized with collections
Save and categorize content based on your preferences.
A heterogeneous migration moves data between different database technologies.
The database engine of the source, such as Oracle differs from the database
engine of the destination, such as PostgreSQL.
Heterogeneous migrations are more complex than homogeneous migrations due to
differences in schema structure, data types, and metadata components between the
source database and the destination database. Database Migration Service provides tools,
such as Gemini-assisted schema and code conversion, that help you
convert the schema and objects from your source database into a format that is
compatible with your destination database.
Heterogeneous migrations use replication based on Change Data Capture (CDC) to
process ongoing changes.
For more information, see supported scenarios.
Supported scenarios
Database Migration Service supports the following heterogeneous migrations:
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Hard to understand","hardToUnderstand","thumb-down"],["Incorrect information or sample code","incorrectInformationOrSampleCode","thumb-down"],["Missing the information/samples I need","missingTheInformationSamplesINeed","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2025-08-07 UTC."],[[["\u003cp\u003eHeterogeneous migration involves moving data between different database technologies, such as from Oracle to PostgreSQL.\u003c/p\u003e\n"],["\u003cp\u003eThese migrations are complex due to variations in schema, data types, and metadata between the source and destination databases.\u003c/p\u003e\n"],["\u003cp\u003eDatabase Migration Service offers tools like Gemini-assisted schema and code conversion to aid in adapting the source database's format to the destination database.\u003c/p\u003e\n"],["\u003cp\u003eChange Data Capture (CDC)-based replication is employed in heterogeneous migrations to manage ongoing data changes.\u003c/p\u003e\n"],["\u003cp\u003eDatabase Migration Service supports specific heterogeneous migration scenarios, including Oracle to Cloud SQL for PostgreSQL and Oracle to AlloyDB for PostgreSQL.\u003c/p\u003e\n"]]],[],null,[]]
