2 databases

Results 1 to 2 of 2

Thread: 2 databases

  1. #1
    Join Date
    Dec 1969

    Default 2 databases

    hi,<BR><BR> I have 2 databases A & B.I have a table called "employee" in A and a table called "employee1" in B.Under "employee" i have a column called "photo" and under "employee1" i have a column called "photo1".what i want to do is that,i want to replace data in "photo1" by data from the column "photo" in the first database.how could i do that?can someone please help?<BR><BR>thanks in advance.

  2. #2
    Join Date
    Dec 1969

    Default RE: 2 databases

    Open up a connection to each database, query the first, get the photo information records, then update the second DB with the appropriate information. I seriously hope you aren&#039;t doing this on a regular basis, and are just transferring some data.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts