Thread: Migrating MySQL DB to PostgreSQL DB.
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,
Best Regards,
Kaushal
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
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
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
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.
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,
Best Regards,
Kaushal
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