| From: | Kaushal Shriyan <kaushalshriyan(at)gmail(dot)com> |
|---|---|
| To: | Ron <ronljohnsonjr(at)gmail(dot)com> |
| Cc: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Migrating MySQL DB to PostgreSQL DB. |
| Date: | 2023-07-31 00:36:11 |
| Message-ID: | CAD7Ssm8uWyWqvCbt2zOc3TCj23uot6f8WM-0DBHBoDqZPHd7_A@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Mon, Jul 31, 2023 at 4:15 AM Ron <ronljohnsonjr(at)gmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kyotaro Horiguchi | 2023-07-31 01:32:25 | Re: Understanding pg_stat_io.evictions |
| Previous Message | Ron | 2023-07-30 22:45:07 | Re: Migrating MySQL DB to PostgreSQL DB. |