first i will explain my data model.

we have one office in US and one office in INDIA, some works are done in US and some work in INDIA also, ie. both the people will update the database, not two-phase commit. one databse only online at a time, time difference help for this. ok i want to update both databases daily.

which method is more optimized, if any body can help me, thanks in advance.