Oracle의 데이터 볼륨을 이동하고 Oracle 상주 애플리케이션 로직을 모두 PostgreSQL로 변환할 수 있는 충분한 다운타임이 있는 경우 Ora2Pg를 사용하여 스키마 변환, 데이터 이동, 코드 변환을 수행하세요.
최소한의 마이그레이션 다운타임을 사용하는 경우 다음 도구를 사용하세요.
마이그레이션
사용
코드 및 스키마
Google Cloud Database Migration Service: 스키마와 코드를 마이그레이션 Ora2Pg: 스키마 변환, 데이터 이동, 코드 변환 변경 데이터 캡처(CDC): Oracle 관계형 테이블에서 데이터를 식별하고 캡처하며 애플리케이션에서 사용할 수 있도록 변경 데이터를 제공하는 도구
[[["이해하기 쉬움","easyToUnderstand","thumb-up"],["문제가 해결됨","solvedMyProblem","thumb-up"],["기타","otherUp","thumb-up"]],[["이해하기 어려움","hardToUnderstand","thumb-down"],["잘못된 정보 또는 샘플 코드","incorrectInformationOrSampleCode","thumb-down"],["필요한 정보/샘플이 없음","missingTheInformationSamplesINeed","thumb-down"],["번역 문제","translationIssue","thumb-down"],["기타","otherDown","thumb-down"]],["최종 업데이트: 2025-09-04(UTC)"],[[["\u003cp\u003eThis page guides users through migrating data from PostgreSQL or Oracle to AlloyDB Omni.\u003c/p\u003e\n"],["\u003cp\u003eFor PostgreSQL migration, tools like \u003ccode\u003epg_dump\u003c/code\u003e, \u003ccode\u003epg_restore\u003c/code\u003e, \u003ccode\u003epgloader\u003c/code\u003e, and \u003ccode\u003epglogical\u003c/code\u003e are recommended based on downtime and complexity.\u003c/p\u003e\n"],["\u003cp\u003eFor Oracle migration with sufficient downtime, \u003ccode\u003eOra2Pg\u003c/code\u003e handles schema conversion, data movement, and code conversion.\u003c/p\u003e\n"],["\u003cp\u003eFor Oracle migration with minimal downtime, use Google Cloud Database Migration Service or \u003ccode\u003eOra2Pg\u003c/code\u003e for code and schema, and \u003ccode\u003eEqualum\u003c/code\u003e for data streaming.\u003c/p\u003e\n"],["\u003cp\u003eAlloyDB Omni usage is subject to the user's existing agreement with Google governing Google Cloud offerings, and if the user doesn't have a google account or an agreement, they should not proceed with downloading the software.\u003c/p\u003e\n"]]],[],null,["# Migrate data to AlloyDB Omni\n\nSelect a documentation version: 15.7.0keyboard_arrow_down\n\n- [Current (16.8.0)](/alloydb/omni/current/docs/migrate-data)\n- [16.8.0](/alloydb/omni/16.8.0/docs/migrate-data)\n- [16.3.0](/alloydb/omni/16.3.0/docs/migrate-data)\n- [15.12.0](/alloydb/omni/15.12.0/docs/migrate-data)\n- [15.7.1](/alloydb/omni/15.7.1/docs/migrate-data)\n- [15.7.0](/alloydb/omni/15.7.0/docs/migrate-data)\n\n\u003cbr /\u003e\n\n| **Note:** Your use of AlloyDB Omni is subject to the agreement between you and Google that governs Google Cloud offerings. If you do not have a Google Cloud account, or have not otherwise entered into an agreement with Google that governs Google Cloud offerings, please do not proceed or download this software until you have done so. To create a Google Cloud account, see [the Google Cloud homepage](/docs/get-started).\n\n\u003cbr /\u003e\n\nThis page outlines the process to migrate data from PostgreSQL or Oracle to\nAlloyDB Omni.\n\n- [PostgreSQL to AlloyDB Omni](#migrate-postgres)\n\n- [Oracle to AlloyDB Omni](#migrate-oracle)\n\nPostgreSQL to AlloyDB Omni\n--------------------------\n\nUse the following tools based on your migration complexity and downtime to migrate data from PostgreSQL to AlloyDB Omni:\n\nOracle to AlloyDB Omni\n----------------------\n\nIf you have sufficient downtime to move the volume of data in Oracle and convert all Oracle resident application logic to PostgreSQL, use [Ora2Pg](https://ora2pg.darold.net/) for schema conversion, data movement, and code conversion.\n\nIf you have minimal downtime for the migration, use the following tools:"]]
