I have a java program which transfers the data from Oracle to MS Sql Server. This program runs every day night. There is a one day lag for updated information in MS SQL Server. I wanted to do this activity online, so that the information will be updated in both the databases simultaneously. To achieve this, when ever there is a table change in oracle I wanted to call this program which will update the MS Sql server database. I don't want to write the trigger on each table to call my java program. Is there any alternatives other that the trigger to achieve this task. Any comments or suggestions are appreciated. Oracle database is Oracle(7.3) and Sql Server Database is (7.0)