Simple Machines Community Forum

SMF Support => SMF 2.0.x Support => PostgreSQL and SQLite Support => Topic started by: Forum Guy on May 22, 2010, 05:32:27 AM

Title: Postgres SMF2 RC3
Post by: Forum Guy on May 22, 2010, 05:32:27 AM
Hi,
I want to change my SMF SQL database to Postgres - is there a transfer tool something?
What's the best way to move data over?



Title: Re: Postgres SMF2 RC3
Post by: CapadY on May 22, 2010, 06:26:58 AM
Have a look at the next:

http://en.wikibooks.org/wiki/Converting_MySQL_to_PostgreSQL
http://articles.sitepoint.com/article/site-mysql-postgresql-2/4
http://jmz.iki.fi/blog/programming/converting_mysql_database_to_postgresql
http://archives.postgresql.org/pgsql-novice/2005-07/msg00159.php
http://dbconvert.com/convert-mysql-to-postgresql-pro.php
Title: Re: Postgres SMF2 RC3
Post by: Forum Guy on May 23, 2010, 03:59:13 AM
thanks for the links but nothing worked for me.
Spending big money on it is no option as it is pure experimental for me - not a life line!

would be a smart idea to have it in phpMyAdmin as export option - until then no Postgres!



Title: Re: Postgres SMF2 RC3
Post by: victor-y on July 23, 2014, 09:28:37 AM
Try this one: spectralcore.com/fullconvert  ;)
Title: Re: Postgres SMF2 RC3
Post by: margarett on July 23, 2014, 10:28:07 AM
Hummmm a post from 2010, the user says he doesn't wish to spend money and you advise a 299$ product?
A bit spammy, don't you think? :)