SQLTeam.com | Weblogs | Forums

Data synchronize in Both Side

sql2008r2

#1

Hi
First time I am going to do replication of Head Office database with the branch offices. A vb.net application will be running in all branches including Head Office. Branches are in remote locations and connected through DYNDNS with firewall protection. database INSERt, UPDATE, DELETE queries will be coming from all locations. Please suggest the best replication method for this criteria.

If its a snapshot replication,it says that "the Publisher sends a snapshot of the published data to Subscribers at scheduled intervals". My question is, If a table, for eg., tblItemMaster, an Item name is updated from a branch, which is a subscriber, will it be reflected in all locations?

Please advise

Thanks in advance


#2

As far as i understand merge replication should work for your needs.


#3

Thanks.. but Microsoft SQL Server Compact Edition can only subscribe to merge publications right?


#4

Don't use Compact Edition.