CODEWITHSUNDEEP
mysqlpostgresql
Wells
Wells

Reputation: 10969

Converting a postgresql database to mysql?

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?

Upvotes: 3

Views: 245

Answers (2)

s_h
s_h

Reputation: 1496

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.

Upvotes: 0

Borealid
Borealid

Reputation: 98459

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.

Upvotes: 4

Related Questions