Re: Migrating MySQL DB to PostgreSQL DB.

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Ken Marshall <ktm(at)rice(dot)edu>, Kaushal Shriyan <kaushalshriyan(at)gmail(dot)com>
Cc: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Migrating MySQL DB to PostgreSQL DB.
Date: 2023-07-30 14:53:44
Message-ID: 81d074f8-4b7c-a418-9f4e-95eab56bab8c@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 7/30/23 07:11, Ken Marshall wrote:
> On Sun, Jul 30, 2023 at 07:31:02PM +0530, Kaushal Shriyan wrote:
>> Hi,
>>
>> I am running MySQL DB 8.0.34 on Red Hat Enterprise Linux release 8.7
>> (Ootpa). Is there a way to import MySQL DB along with data to PostgreSQL 14
>> database server?
>>
>> Please suggest. Thanks in advance.
>>
>> Best Regards,
>>
>> Kaushal
>
> Hi Kaushal,
>
> Ora2Pg may work for you:
>
> https://ora2pg.darold.net/

There is also pgloader:

https://pgloader.io/

>
> Regards,
> Ken
>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Peter J. Holzer 2023-07-30 15:34:37 Re: Upgrading
Previous Message Ken Marshall 2023-07-30 14:11:51 Re: Migrating MySQL DB to PostgreSQL DB.