pg.ddx.io pgsql-general@postgresql.org mailing list archive
help / color / mirror / Atom feedMigrating MySQL DB to PostgreSQL DB.
7+ messages / 5 participants
[nested] [flat]
* Migrating MySQL DB to PostgreSQL DB.
@ 2023-07-30 14:01 Kaushal Shriyan <kaushalshriyan@gmail.com>
0 siblings, 2 replies; 7+ messages in thread
From: Kaushal Shriyan @ 2023-07-30 14:01 UTC (permalink / raw)
To: pgsql-general
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
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Migrating MySQL DB to PostgreSQL DB.
@ 2023-07-30 14:11 Ken Marshall <ktm@rice.edu>
parent: Kaushal Shriyan <kaushalshriyan@gmail.com>
1 sibling, 1 reply; 7+ messages in thread
From: Ken Marshall @ 2023-07-30 14:11 UTC (permalink / raw)
To: Kaushal Shriyan <kaushalshriyan@gmail.com>; +Cc: pgsql-general
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/
Regards,
Ken
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Migrating MySQL DB to PostgreSQL DB.
@ 2023-07-30 14:53 Adrian Klaver <adrian.klaver@aklaver.com>
parent: Ken Marshall <ktm@rice.edu>
0 siblings, 1 reply; 7+ messages in thread
From: Adrian Klaver @ 2023-07-30 14:53 UTC (permalink / raw)
To: Ken Marshall <ktm@rice.edu>; Kaushal Shriyan <kaushalshriyan@gmail.com>; +Cc: 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.klaver@aklaver.com
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Migrating MySQL DB to PostgreSQL DB.
@ 2023-07-30 17:53 Kaushal Shriyan <kaushalshriyan@gmail.com>
parent: Adrian Klaver <adrian.klaver@aklaver.com>
0 siblings, 0 replies; 7+ messages in thread
From: Kaushal Shriyan @ 2023-07-30 17:53 UTC (permalink / raw)
To: Adrian Klaver <adrian.klaver@aklaver.com>; +Cc: Ken Marshall <ktm@rice.edu>; pgsql-general
Thanks Ken and Adrian for the quick email response. Really appreciate it.
Thanks once again👍
Best Regards,
Kaushal
On Sun, Jul 30, 2023 at 8:23 PM Adrian Klaver <adrian.klaver@aklaver.com>
wrote:
> 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.klaver@aklaver.com
>
>
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Migrating MySQL DB to PostgreSQL DB.
@ 2023-07-30 22:45 Ron <ronljohnsonjr@gmail.com>
parent: Kaushal Shriyan <kaushalshriyan@gmail.com>
1 sibling, 1 reply; 7+ messages in thread
From: Ron @ 2023-07-30 22:45 UTC (permalink / raw)
To: pgsql-general@lists.postgresql.org
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.
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Migrating MySQL DB to PostgreSQL DB.
@ 2023-07-31 00:36 Kaushal Shriyan <kaushalshriyan@gmail.com>
parent: Ron <ronljohnsonjr@gmail.com>
0 siblings, 1 reply; 7+ messages in thread
From: Kaushal Shriyan @ 2023-07-31 00:36 UTC (permalink / raw)
To: Ron <ronljohnsonjr@gmail.com>; +Cc: pgsql-general@lists.postgresql.org
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
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Migrating MySQL DB to PostgreSQL DB.
@ 2023-07-31 02:26 Tom Browder <tom.browder@gmail.com>
parent: Kaushal Shriyan <kaushalshriyan@gmail.com>
0 siblings, 0 replies; 7+ messages in thread
From: Tom Browder @ 2023-07-31 02:26 UTC (permalink / raw)
To: Kaushal Shriyan <kaushalshriyan@gmail.com>; pgsql-general <pgsql-general@lists.postgresql.org>
On Sun, Jul 30, 2023 at 19:36 Kaushal Shriyan <kaushalshriyan@gmail.com>
wrote:
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/) ?
>
Check out Dbeaver (dbeaver.com).
-Tom
^ permalink raw reply [nested|flat] 7+ messages in thread
end of thread, other threads:[~2023-07-31 02:26 UTC | newest]
Thread overview: 7+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2023-07-30 14:01 Migrating MySQL DB to PostgreSQL DB. Kaushal Shriyan <kaushalshriyan@gmail.com>
2023-07-30 14:11 ` Ken Marshall <ktm@rice.edu>
2023-07-30 14:53 ` Adrian Klaver <adrian.klaver@aklaver.com>
2023-07-30 17:53 ` Kaushal Shriyan <kaushalshriyan@gmail.com>
2023-07-30 22:45 ` Ron <ronljohnsonjr@gmail.com>
2023-07-31 00:36 ` Kaushal Shriyan <kaushalshriyan@gmail.com>
2023-07-31 02:26 ` Tom Browder <tom.browder@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox