Postgres Pro
Downloads
Home   >   mailing lists

Re: Migrating MySQL DB to PostgreSQL DB. - Mailing list pgsql-general

From Kaushal Shriyan
Subject Re: Migrating MySQL DB to PostgreSQL DB.
Date
Msg-id CAD7Ssm8uWyWqvCbt2zOc3TCj23uot6f8WM-0DBHBoDqZPHd7_A@mail.gmail.com
Whole thread Raw
In response to Re: Migrating MySQL DB to PostgreSQL DB.  (Ron <ronljohnsonjr@gmail.com>)
Responses Re: Migrating MySQL DB to PostgreSQL DB.  (Tom Browder <tom.browder@gmail.com>)
List pgsql-general
Tree view


On Mon, Jul 31, 2023 at 4:15 AM Ron <ronljohnsonjr@gmail.com> wrote:
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.


Thanks Ron for the suggestion. Much appreciated. Are there any PostgreSQL GUI applications for MacOS, Windows and Linux similar to MySQL Workbench (https://www.mysql.com/products/workbench/) ?

Please suggest. Thanks in advance.

Best Regards,

Kaushal

pgsql-general by date:

Previous
From: Ron
Date:
Subject: Re: Migrating MySQL DB to PostgreSQL DB.
Next
From: Kyotaro Horiguchi
Date:
Subject: Re: Understanding pg_stat_io.evictions