Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2011
    Posts
    2

    Unanswered: Best approach to update field information from one database to another.

    Hi,

    In my application, we have to work with 2 databases.

    1. First database(D1) is where we get all the updated information.
    like userID, emailID, status, dept etc. lets call table "ABC", which can contain more than 4 Lakhs record.

    2. Second database(D2) is where we need to update to the table "XYZ" by retrieving data from D1."ABC". Table "XYZ" can contain "25 to 50 thousand records".

    Problem:
    Now, I need to update status information in table D2."XYZ" by retrieving status field data from table D1."ABC" using "userID" as primary and foreign key.

    May I know the best approach to update the status information of 50,000 records of database (D2) from 4 Lakhs records of database (D2)?

    Thanks,
    Chinnu

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Quote Originally Posted by Chinnu55 View Post
    May I know the best approach to update the status information
    I think the best would be to use an UPDATE statement.

Posting Permissions

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