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
You have posted it as an Article under the Article / Source code section. I have moved it to the Queries and Discussion forum.
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.
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
