I have a database server in HQ, while in branch I need user able to get the data from database server to perform daily task. The problem is the connectivity is not that good. I wish to have another set of data which from HQ database server to sit in branch to let user to do a daily task and what ever update in branch will sync back to database server in HQ and vice versa. Any idea how I can do this? using replication or mirroring and any reference I can refer how to do this?