1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

connection of mysql and pgsql database simultaneously

Discussion in 'PHP' started by gaurav471, Jan 11, 2007.

  1. gaurav471

    gaurav471 New Member

    Joined:
    Jan 9, 2007
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    0
    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 :)
     
  2. shabbir

    shabbir Administrator Staff Member

    Joined:
    Jul 12, 2004
    Messages:
    15,283
    Likes Received:
    364
    Trophy Points:
    83
  3. pradeep

    pradeep Team Leader

    Joined:
    Apr 4, 2005
    Messages:
    1,646
    Likes Received:
    86
    Trophy Points:
    0
    Occupation:
    Programmer
    Location:
    Kolkata, India
    Home Page:
    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.
     
  4. gaurav471

    gaurav471 New Member

    Joined:
    Jan 9, 2007
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    0
    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
     

Share This Page