Re: Migrating MySQL DB to PostgreSQL DB.

From: Ron <ronljohnsonjr(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Migrating MySQL DB to PostgreSQL DB.
Date: 2023-07-30 22:45:07
Message-ID: c471c950-ecbd-31e1-937b-ad0d131bab4e@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 7/30/23 09:01, 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.

Depending on the size of the database, the "exoticness" of the datatypes,
the amount of downtime available and how complicated any stored procedures
and triggers are, simple CSV export/import might do the trick.

--
Born in Arizona, moved to Babylonia.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Kaushal Shriyan 2023-07-31 00:36:11 Re: Migrating MySQL DB to PostgreSQL DB.
Previous Message Kaushal Shriyan 2023-07-30 17:53:52 Re: Migrating MySQL DB to PostgreSQL DB.