pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedFrom: ji hwan song <song7357@gmail.com>
To: Muhammad Waqas <waqas.m@bitnine.net>
Cc: Sam Stearns <sam.stearns@dat.com>
Cc: pgsql-admin@lists.postgresql.org, Catherine Schulz <catherine.schulz@dat.com>
Cc: Peter Garza <peter.garza@dat.com>
Cc: Henry Ashu <henry.ashu@dat.com>
Subject: Re: Oracle to Postgres
Date: Fri, 12 Jul 2024 22:13:34 +0900
Message-ID: <CAHTrd785mvmau50pfh_BVSyO2FPbaaFNRvBGdU3tm6rJcNff5w@mail.gmail.com> (raw)
In-Reply-To: <CAHYHq4Vpr=G0CWA7nKS4JETXYGCs3KJEebDriii-jXEN+RFJtQ@mail.gmail.com>
References: <CAN6TVjmHpfJ+Q_HJcnrNUoDNghwkQ5WKVL_gh4iBTUzOhAG=1Q@mail.gmail.com>
<CAHYHq4Vpr=G0CWA7nKS4JETXYGCs3KJEebDriii-jXEN+RFJtQ@mail.gmail.com>
저는 한국의 20년차 dba 입니다. 현재 oracle /tibero db , podstgres,/edb/mysql /mariadb
, 서로 migration 할수 있는 java 된 프로그램 만들었습니다.
기능은 source db 와 targetdb 의 스키마 연동 ( table생성 ,pk 와 pk index 자동 생성 기능 ,
source db target db data migration 기능 까지 가능 합니다.
아직까지는 다양한 스키마로 테스트 안되었습니다. 저에게 oracle 11 버전 dump 파일을 보내주시면 테스트 해보고 소스 제공해
드리겠습니다.
2024년 7월 12일 (금) 오후 8:39, Muhammad Waqas <waqas.m@bitnine.net>님이 작성:
> ora2pg for object migration
> sqllines for data migration
>
> above tools are tested
>
> 2024년 7월 12일 (금) 오전 5:02, Sam Stearns <sam.stearns@dat.com>님이 작성:
>
>> Howdy,
>>
>> We have a project to migrate our Oracle databases that are hosted on an
>> Oracle Database Appliance to Postgres hosted on a Linux VM. Questions:
>>
>>
>> 1. Is there a tool out there that we can use to analyze resource
>> sizing on the Appliance that will give resource sizing recommendations for
>> the VM?
>> 2. Is there a schema conversion tool or similar out there that we can
>> use to convert Oracle ==> Postgres?
>>
>> Thanks,
>>
>> Sam
>>
>> --
>>
>> *Samuel Stearns*
>> Lead Database Administrator
>> *c:* 971 762 6879 | *o:* 503 672 5115 | DAT.com
>> [image: DAT]
>> <https://www.dat.com/?utm_medium=email&utm_source=DAT_email_signature_link;
>>
>
view thread (20+ messages) latest in thread
Message-ID: <CAHTrd785mvmau50pfh_BVSyO2FPbaaFNRvBGdU3tm6rJcNff5w@mail.gmail.com>
Permalink: ../CAHTrd785mvmau50pfh_BVSyO2FPbaaFNRvBGdU3tm6rJcNff5w@mail.gmail.com/
Also on: postgresql.org/message-id/CAHTrd785mvmau50pfh_BVSyO2FPbaaFNRvBGdU3tm6rJcNff5w@mail.gmail.com
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: song7357@gmail.com, waqas.m@bitnine.net, sam.stearns@dat.com, catherine.schulz@dat.com, peter.garza@dat.com, henry.ashu@dat.com
Subject: Re: Oracle to Postgres
In-Reply-To: <CAHTrd785mvmau50pfh_BVSyO2FPbaaFNRvBGdU3tm6rJcNff5w@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox