Postgres Pro
Downloads
Home   >   mailing lists

RE: MySQL to PostgreSQL converter? - Mailing list pgsql-novice

From Stephen Froehlich
Subject RE: MySQL to PostgreSQL converter?
Date
Msg-id DM6PR06MB488973072D4A3E2EDB2F4463E5B00@DM6PR06MB4889.namprd06.prod.outlook.com
Whole thread Raw
In response to MySQL to PostgreSQL converter?  (Stephen Froehlich <s.froehlich@cablelabs.com>)
List pgsql-novice
Tree view

I should add that the only thing that is remotely tricky about this database is that most of the big tables are partitioned (its all time series data and metadata).

 

--Stephen

 

From: Stephen Froehlich <s.froehlich@cablelabs.com>
Sent: Thursday, September 12, 2019 10:48 AM
To: pgsql-novice@lists.postgresql.org
Subject: MySQL to PostgreSQL converter?

 

Hi all,

 

I was excited/relieved to see that AWS is now (finally) offering a PostgreSQL aurora serverless service … I have been using MySQL serverless for a given project but am quite frustrated with the immaturity of the RMySQL package compared to RPostgres and a number of issues it causes, so I would like to convert the database over (which is a non-live analysis database, so I can do a dump, convert, and restore with relative ease).

 

What tools do you like for this kind of conversion?

 

Thanks,

Stephen

 

Stephen Froehlich
Sr. Strategist, CableLabs®


s.froehlich@cablelabs.com

Tel: +1 (303) 661-3708

 

pgsql-novice by date:

Previous
From: Stephen Froehlich
Date:
Subject: MySQL to PostgreSQL converter?
Next
From: Thomas Kellerer
Date:
Subject: Re: MySQL to PostgreSQL converter?