Simple Machines Community Forum

Archived Boards and Threads... => Archived Boards => SMF Feedback and Discussion => Aiheen aloitti: falguni1 - joulukuu 19, 2007, 09:32:14 AP

Otsikko: sql to postgresql
Kirjoitti: falguni1 - joulukuu 19, 2007, 09:32:14 AP
I have a sql database as I use smf 1.1.4

after I upgrade to smf 2.0 how do I change my database from sql to postgresql.
Otsikko: Re: sql to postgresql
Kirjoitti: Dragooon - joulukuu 19, 2007, 09:33:07 AP
I don't think so you can.
But why you want it?
Otsikko: Re: sql to postgresql
Kirjoitti: 青山 素子 - joulukuu 19, 2007, 11:14:36 AP
Lainaus käyttäjältä: falguni1 - joulukuu 19, 2007, 09:32:14 AP
after I upgrade to smf 2.0 how do I change my database from sql to postgresql.

As far as I know, we don't have a conversion tool ready yet. However, as we are still in the beta phase and some of the database details are still being worked on, that isn't to be unexpected.
Otsikko: Re: sql to postgresql
Kirjoitti: H - joulukuu 19, 2007, 11:44:34 AP
I imagine some tools may be written by us although as Motoko-Chan says we are still in beta :). There are some good MySQL > PostgreSQL programs available which may work (although you'll have to compare datatypes with the install.sql file for best performance) :)
Otsikko: Re: sql to postgresql
Kirjoitti: Douglas - joulukuu 19, 2007, 02:37:17 IP
Obvious question... but are/were you a Charter Member, falguni1?
Otsikko: Re: sql to postgresql
Kirjoitti: Grudge - joulukuu 19, 2007, 03:37:02 IP
There will be no tool for converting from mysql to postgresql written by SM, there may however be tools available on the internet for this.
Otsikko: Re: sql to postgresql
Kirjoitti: falguni1 - joulukuu 20, 2007, 12:15:33 IP
I want to start a new forum and now we have smf 1.1.4 I will have sql database.
I want postgresql
so I think now maybe I will start my forum after smf 2.0 is released so that I have postgresql.