Simple Machines Community Forum

SMF Support => SMF 2.0.x Support => PostgreSQL and SQLite Support => Topic started by: GreenSage on July 23, 2015, 12:00:26 PM

Title: Any current way to convert MySQL database to PostGreSQL?
Post by: GreenSage on July 23, 2015, 12:00:26 PM
Hello all,

All of the links and tools I've found for migrating a MySQL database to PostGreSQL was from 2010 or earlier and the links have "expired." Is there any current information I can use? I can't afford the $300 product right now...anything freeware that can help me? I would just like to experience my forum in PostGresSQL for the time being, check it out.
Title: Re: Any current way to convert MySQL database to PostGreSQL?
Post by: Kindred on July 23, 2015, 12:03:21 PM
in short...   don't do it.

I can not recommend using PostGreSQL -- especially not in place of mySQL.

If, for some reason, you can not run mySQL  (mySQL is free...   what would this $300 be?)
you could try MariaDB
Title: Re: Any current way to convert MySQL database to PostGreSQL?
Post by: GreenSage on July 23, 2015, 12:12:45 PM
in short...   don't do it.

I can not recommend using PostGreSQL -- especially not in place of mySQL.

If, for some reason, you can not run mySQL  (mySQL is free...   what would this $300 be?)
you could try MariaDB

The "spammy" link in one of the other threads in here lol.
Title: Re: Any current way to convert MySQL database to PostGreSQL?
Post by: Kindred on July 23, 2015, 12:40:20 PM
What?
Title: Re: Any current way to convert MySQL database to PostGreSQL?
Post by: margarett on July 23, 2015, 12:46:01 PM
He found, in one of the topics returned by his search, a software to perform the conversion, which costs $300

Well, as said it isn't recommended. Not that PG is better or worse but the fact is that everything is developed towards MySQL and then "adjusted to work" in PG.
With that said --> http://wiki.postgresql.org/wiki/Converting_from_other_Databases_to_PostgreSQL#MySQL
Title: Re: Any current way to convert MySQL database to PostGreSQL?
Post by: mioux on November 18, 2016, 05:49:12 AM
I don't know if you have switched from mysql to postgresql, but I have used https://github.com/AnatolyUss/nmig for data migration

But I don't have switched SMF... I don't know why I have errors when switching :D

FYI, I don't want to use MariaDB anymore due to stability issues. Original MySQL is not provided in my distribution, so I can't switch easily