Re: [PHP] Converting PHP code and db schema from PostgreSQL to MySQL

[Greg Donald]

On Mon, 20 Sep 2004 16:18:26 +0300, Stefan Moldoveanu
<[EMAIL PROTECTED]> wrote:
> Is there any tool/script to convert PostgreSQL code from PHP scripts into
> MySQL (pg_connect > mysql_connect and so forth)?
> I'm talking about a website with thousands of code lines.

In vi:
:%s/pg_/mysql_/g

> Also, any script which can convert PostgreSQL db data schema to MySQL? I
> only found tutorials for MySQL > PostgreSQL conversion.

That's because you're a minority.  Most people upgrade to Postgres,
not downgrade to MySQL.  If it were me I'd see what my2pg.pl does and
reverse the logic.

> Any link / tutorial / etc. would be highly appreciated.

I recommend using ADOdb, just in case you change your mind later and
want to switch databases again you'd be set:
http://adodb.sourceforge.net/


-- 
Greg Donald
http://gdconsultants.com/
http://destiney.com/

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] Converting PHP code and db schema from PostgreSQL to MySQL

[Stefan Moldoveanu]

Hello, folks,
 
Is there any tool/script to convert PostgreSQL code from PHP scripts into
MySQL (pg_connect > mysql_connect and so forth)?
I'm talking about a website with thousands of code lines.
 
Also, any script which can convert PostgreSQL db data schema to MySQL? I
only found tutorials for MySQL > PostgreSQL conversion.
 
 
Any link / tutorial / etc. would be highly appreciated.
 
 
Thank you,
Stefan