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?
Join the Stack Overflow Community
Stack Overflow is a community of 6.5 million programmers, just like you, helping each other.
Join them; it only takes a minute:
Sign up
Join them; it only takes a minute:
|
|
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. |
|||||||||
|
|
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. |
||||
|
|
