PDA

View Full Version : Coverting a from PostgreSQL to MySQL


gsnedders
09-06-2004, 12:55 AM
I haven't found anything which can do this, do you know of any?

firepages
09-06-2004, 04:56 AM
converting a what ? a DB ? a query ? ;)

gsnedders
09-07-2004, 07:15 PM
:eek: What a mistake :o It meant to read Converting a site from PostgreSQL to MySQL...

As for your question, both.

raf
09-08-2004, 10:48 AM
you need to give more info.

'a site' isn't realy a lott to go on. If you used a db-abstraction layer, like PEAR db then it's just creating exports from the PostGre and importing them into MySQL. If you didn't use a db-abstraction, then you'll need to also do the export-imports, but additionally, you need to go over all your code and rewrite all querys that are different for MySQL.
It then depends on what sort of querys 'a site' used + how much db-interaction there is, to know if it's a lott of work and to know if a script exists or can be written.

gsnedders
09-08-2004, 08:52 PM
Oh well, I've found a host which supports PostgreSQL... *sigh*... I'll convert it later... (More info will be provided at a later date).