Advertisement:

Author Topic: Any current way to convert MySQL database to PostGreSQL?  (Read 18370 times)

Offline Blu Ace 13

  • Jr. Member
  • **
  • Posts: 103
  • Gender: Male
  • The Will to Change the world.
    • The Xeno Society
Any current way to convert MySQL database to PostGreSQL?
« 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.

Offline Kindred

  • The Mean One
  • Support Specialist
  • SMF Legend
  • *
  • Posts: 53,869
  • Gender: Male
    • Kindred-999 on GitHub
Re: Any current way to convert MySQL database to PostGreSQL?
« Reply #1 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
Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

Offline Blu Ace 13

  • Jr. Member
  • **
  • Posts: 103
  • Gender: Male
  • The Will to Change the world.
    • The Xeno Society
Re: Any current way to convert MySQL database to PostGreSQL?
« Reply #2 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.

Offline Kindred

  • The Mean One
  • Support Specialist
  • SMF Legend
  • *
  • Posts: 53,869
  • Gender: Male
    • Kindred-999 on GitHub
Re: Any current way to convert MySQL database to PostGreSQL?
« Reply #3 on: July 23, 2015, 12:40:20 PM »
What?
Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

Offline margarett

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,762
  • Gender: Male
Re: Any current way to convert MySQL database to PostGreSQL?
« Reply #4 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
Se forem conduzir, não bebam. Se forem beber... CHAMEM-ME!!!! :D

Quote
Over 90% of all computer problems can be traced back to the interface between the keyboard and the chair

Offline mioux

  • Newbie
  • *
  • Posts: 4
Re: Any current way to convert MySQL database to PostGreSQL?
« Reply #5 on: November 18, 2016, 05:49:12 AM »
I don't know if you have switched from mysql to postgresql, but I have used hxxp:github.com/AnatolyUss/nmig [nonactive] 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