Postgres Pro
Downloads
Home   >   mailing lists

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

From Ron
Subject Re: Migrating MySQL DB to PostgreSQL DB.
Date
Msg-id c471c950-ecbd-31e1-937b-ad0d131bab4e@gmail.com
Whole thread Raw
In response to Migrating MySQL DB to PostgreSQL DB.  (Kaushal Shriyan <kaushalshriyan@gmail.com>)
Responses Re: Migrating MySQL DB to PostgreSQL DB.
List pgsql-general
Tree view 
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.

pgsql-general by date:

Previous
From: Kaushal Shriyan
Date:
Subject: Re: Migrating MySQL DB to PostgreSQL DB.
Next
From: Kaushal Shriyan
Date:
Subject: Re: Migrating MySQL DB to PostgreSQL DB.