Converting a postgresql database to mysql?

Question

I've been a'Googling and there's all sorts of various forms of crazy ideas out there, but, dear Stack Overflow geniuses, is there a stable, reliable form of converting a postgresql database to a mysql database on Linux?

PostgreSQL has DbLink, but it's only for connecting to other PostgreSQL instances. — OMG Ponies
– OMG Ponies, Commented Aug 20, 2010 at 3:57

Borealid · Accepted Answer · 2010-08-20 04:04:13Z

4

You can write a program which connects to both databases and reads records from PostGres, inserting to MySQL. You'll have to do the schemas by hand.

This is a pretty common way to do database migrations... An automated tool would be nice, but the differences in functionality are so subtle that I'm not sure one exists.

answered Aug 20, 2010 at 4:04

Borealid

99.4k9 gold badges111 silver badges123 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Erik S Over a year ago

This is also what i fear i'd have to use... However, seeing as that seems the only solution, i expected to find at least some basic tool to build one...

wallyk · Accepted Answer · 2010-08-20 04:15:43Z

0

I believe that you can work with a Data Pump tool in order to import information from ADO-compatible sources into Mysql. You will have to double check with stored procedures as an example... but tables, fields and data could be imported - in my experience - using those tools with no problem. I suggest you to check http://www.sqlmanager.net/en/products/mysql/datapump and try.. rgds.

edited Aug 20, 2010 at 4:15

wallyk

58.1k17 gold badges92 silver badges155 bronze badges

answered Aug 20, 2010 at 4:14

s_h

1,5062 gold badges27 silver badges63 bronze badges

Collectives™ on Stack Overflow

Converting a postgresql database to mysql?

2 Answers 2

1 Comment

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Related