RE: MySQL to PostgreSQL converter?

Stephen Froehlich <[email protected]> Thu, 12 Sep 2019 16:52:01 +0000

Newsgroups	gmane.comp.db.postgresql.novice
Message-ID	<DM6PR06MB488973072D4A3E2EDB2F4463E5B00@DM6PR06MB4889.namprd06.prod.outlook.com>

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 <[email protected]>
Sent: Thursday, September 12, 2019 10:48 AM
To: [email protected]
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(r)

[email protected]<mailto:[email protected]>
Tel: +1 (303) 661-3708