connection of mysql and pgsql database simultaneously

gaurav471's Avatar, Join Date: Jan 2007
Newbie Member
hi,
i have a application in which, my website is residing in one server (name: server1) and database is MYSQl, and my application resides in another server and database is PGSQL (name: server2), and i want to transfer some data from server1 to server2 depending on some action. and i m using PHP for development.
how can i do that, please help me out ...
i have no idea how it can be done ...
with regards,
Gaurav Raj
0
shabbir's Avatar, Join Date: Jul 2004
Go4Expert Founder
You have posted it as an Article under the Article / Source code section. I have moved it to the Queries and Discussion forum.
0
pradeep's Avatar, Join Date: Apr 2005
Team Leader
Yes! That's absolutely possible, you need to connect to both servers and fetch row by row from the source server and insert it into the target server. Just keep in mind whether some data format conversion is needed before transferring.
0
gaurav471's Avatar, Join Date: Jan 2007
Newbie Member
thanks,
but how to connect both server simultaneously, i m using apache srver 2.0.
and best will be, if u will provide full details, it will be very helpful.
thanks in advance ...
with regards,
Gaurav Raj