Mantieni tutto organizzato con le raccolte
Salva e classifica i contenuti in base alle tue preferenze.
Una migrazione eterogenea sposta i dati tra diverse tecnologie di database.
Il motore del database di origine, ad esempio Oracle, è diverso dal motore del database di destinazione, ad esempio PostgreSQL.
Le migrazioni eterogenee sono più complesse di quelle omogenee a causa delle differenze nella struttura dello schema, nei tipi di dati e nei componenti dei metadati tra il database di origine e quello di destinazione. Database Migration Service fornisce strumenti, come la conversione di schema e codice assistita da Gemini, che ti aiutano a trasformare lo schema e gli oggetti del database di origine in un formato compatibile con il database di destinazione.
Le migrazioni eterogenee utilizzano la replica basata su Change Data Capture (CDC) per elaborare le modifiche in corso.
Per ulteriori informazioni, consulta gli scenari supportati.
Scenari supportati
Database Migration Service supporta le seguenti migrazioni eterogenee:
[[["Facile da capire","easyToUnderstand","thumb-up"],["Il problema è stato risolto","solvedMyProblem","thumb-up"],["Altra","otherUp","thumb-up"]],[["Difficile da capire","hardToUnderstand","thumb-down"],["Informazioni o codice di esempio errati","incorrectInformationOrSampleCode","thumb-down"],["Mancano le informazioni o gli esempi di cui ho bisogno","missingTheInformationSamplesINeed","thumb-down"],["Problema di traduzione","translationIssue","thumb-down"],["Altra","otherDown","thumb-down"]],["Ultimo aggiornamento 2025-09-05 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,["# Heterogeneous migrations\n\nA heterogeneous migration moves data between different database technologies.\nThe database engine of the source, such as Oracle differs from the database\nengine of the destination, such as PostgreSQL.\n\nHeterogeneous migrations are more complex than homogeneous migrations due to\ndifferences in schema structure, data types, and metadata components between the\nsource database and the destination database. Database Migration Service provides tools,\nsuch as Gemini-assisted schema and code conversion, that help you\nconvert the schema and objects from your source database into a format that is\ncompatible with your destination database.\n\nHeterogeneous migrations use replication based on Change Data Capture (CDC) to\nprocess ongoing changes.\n\nFor more information, see supported scenarios.\n\nSupported scenarios\n-------------------\n\nDatabase Migration Service supports the following heterogeneous migrations:\n\n- [Migrate from Oracle to Cloud SQL for PostgreSQL](/database-migration/docs/oracle-to-postgresql/scenario-overview)\n- [Migrate from Oracle to AlloyDB for PostgreSQL](/database-migration/docs/oracle-to-alloydb/scenario-overview)\n- [Migrate from SQL Server to Cloud SQL for PostgreSQL](/database-migration/docs/sqlserver-to-csql-pgsql/scenario-overview)\n- [Migrate from SQL Server to AlloyDB for PostgreSQL](/database-migration/docs/sqlserver-to-alloydb/scenario-overview)"]]