thanks for u reply.

here one should not touch live DB and we need to put another DB(testDB) on the same server and required to push data for every 2 hrs...

thanks all for replies.

here my requirements changed and finalized.

we have a live DB and need to push data for every 2 hrs to test DB(which is on same server) and...

thanks all

my requirement is to push data for every 2 hrs to the live database.

Thanks a lot. is there any other process to replicate data other than snap shot and transactional..