we have one database in Hyderabad location few of our team members will be working from MUMBAI as well. as of now we are working on remote desktop connections. we would like to look for speed up the process.Remote desktop is very slow even though we have LEASED LINE Connection.
Can any one suggest me ? is it possible to implement any Replication , im worried when the connection is going Down what will happen ?
If the Connection Leased Line Connection Goes Down; if any update is happening in Hyderabad , and at the same time on same table Mumbai also updates what will happen to the data once the leased Line connection comes to normal.