Toad World® Forums

Script that compares two db,s and updates db and insert date of update


#1

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? Can anyone help mee whit this?


#2

Do you have a database link?

Depending on how busy your table is, a simple trigger would handle insert, update, and delete activity, but would only work one way.