• Hi

    you can schedule the job which will execute after every 1 hour to synchronise database.

    For synchronising as Lowell has suggested, a trigger can update date column or a flag which will mark records for synchronisation. Later your jobs picks up those records and reset the flag.

    In a way it is doing replication.

    Thanks,

    Rupashri