Go4Expert

Go4Expert (http://www.go4expert.com/)
-   PHP (http://www.go4expert.com/forums/php/)
-   -   connection of mysql and pgsql database simultaneously (http://www.go4expert.com/forums/connection-mysql-pgsql-database-t2522/)

gaurav471 11Jan2007 18:02

connection of mysql and pgsql database simultaneously
 
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 :)

shabbir 11Jan2007 18:23

Re: connection of mysql and pgsql database simultaneously
 
You have posted it as an Article under the Article / Source code section. I have moved it to the Queries and Discussion forum.

pradeep 11Jan2007 18:29

Re: connection of mysql and pgsql database simultaneously
 
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.

gaurav471 12Jan2007 11:14

Re: connection of mysql and pgsql database simultaneously
 
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


All times are GMT +5.5. The time now is 12:04.