On 15 July 2014 14:55:14 CEST, James <wirel...@tampabay.rr.com> wrote: >Hello, > >I recently ran across this script: py-mysql2pgsql [1] >and this discussion on it's origin [2]. I'm keenly interested >in the recommendations of others for migrating mysql databases >to postgresql and any comments on this aforementioned script >or other methodologies.... > > >TIA, >James > > >[1] https://github.com/philipsoutham/py-mysql2pgsql > >[2] >http://www.tryolabs.com/Blog/2012/02/10/django-migrating-mysql-postgresql/
James, I haven't looked into this recently. But I believe that the DDLs and data can be migrated relatively easy. Just be aware that software specifically written using MySQLs version of SQL is unlikely to work on a different RDBMS without extensive rewrites. This is the biggest problem people are facing when porting websites to use a different database. What is the reason for migrating and what kind of data and applications are you using? -- Joost -- Sent from my Android device with K-9 Mail. Please excuse my brevity.