pg.ddx.io  pgsql-general@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Migrating 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