#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2013
    Posts
    5
    Rep Power
    0

    Create an sql script that compares two db,s and updates db and insert date of update


    Hi i need some help creating an sql script that can update info from one table in dbase1 to another table in dbase2 that has the same columns and if posible insert date and time in one column when the syncronized is done?
  2. #2
  3. Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Apr 2012
    Location
    spaceBAR Central
    Posts
    225
    Rep Power
    41
    Do you only want to update row(s) in dbase2 table for the row(s) that exist in dbase1 table?

    What if a row exists in dbase1 table and not in dbase2 table?

    Provide sample ddl for table and it's index(s).
  4. #3
  5. Contributing User
    Devshed Novice (500 - 999 posts)

    Join Date
    Sep 2006
    Posts
    834
    Rep Power
    387

    Cool


    Originally Posted by miguel_q@hotmai
    Hi i need some help creating an sql script that can update info from one table in dbase1 to another table in dbase2 that has the same columns and if posible insert date and time in one column when the syncronized is done?
    1) Create database link
    2) Use MERGE statement
  6. #4
  7. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2013
    Posts
    5
    Rep Power
    0

    Many Thnaks!


    Originally Posted by LKBrwn_DBA
    1) Create database link
    2) Use MERGE statement
    Yes i did this:
    I created a dbms schedule.
    and i created a dblink
    and i created a compare query and now i have some problem with creating a procedure i have posted it on the forum. I will appreciate all help i can get.

IMN logo majestic logo threadwatch logo seochat tools logo