MySQL to PostgreSQL converter?

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

MySQL to PostgreSQL converter?

Stephen Froehlich

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®


[hidden email]

Tel: +1 (303) 661-3708

 

Reply | Threaded
Open this post in threaded view
|

RE: MySQL to PostgreSQL converter?

Stephen Froehlich

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 <[hidden email]>
Sent: Thursday, September 12, 2019 10:48 AM
To: [hidden email]
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®


[hidden email]

Tel: +1 (303) 661-3708

 

Reply | Threaded
Open this post in threaded view
|

Re: MySQL to PostgreSQL converter?

Thomas Kellerer
In reply to this post by Stephen Froehlich
Stephen Froehlich schrieb am 12.09.2019 um 18:47:
> 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?

ora2pg - despite the name - can also migrate a MySQL database to Postgres.


https://ora2pg.darold.net/



Reply | Threaded
Open this post in threaded view
|

RE: MySQL to PostgreSQL converter?

Stephen Froehlich
In reply to this post by Stephen Froehlich

Thanks for all of the suggestions … I should also note that because its going into AWS, the relevant integrator in our IT department suggested the AWS Database Migration Service, which is actually where I’m starting.

I got a private suggestion for pgloader, which will be the second option I try if the database migration service doesn’t work out.


Also, our integrator likes DataGrip as a commercial tool to move between databases.

 

--Stephen

 

From: Stephen Froehlich <[hidden email]>
Sent: Thursday, September 12, 2019 10:48
To: [hidden email]
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®


[hidden email]

Tel: +1 (303) 661-3708