I have two SQL servers located on different physical location i.e. in different cities. I want to integrate the databases. If there is a Change in DB of location#1 then it should be updated in DB of location #2. Suppose we inducted an employee at location#1 then we will add a record in employee table. The record should be updated in employee table in the database at location#2.
Please let me know which is the best scinario to achieve the above keeping in mind we sometime loss our VPN connection between two locations.

eJ@z

I suggest you try looking into log shipping.