I am contemplating using SQL Server merge replication to keep 10-20 clients synchronized with one of our 2008 SQL Servers. The reason I am looking at merge replication is that in some cases the clients (users) won't have network access and will need
to reference and add information that would need to then be sync'd when they regain access. I have started doing some Proof of Concept testing, but wanted to get the opinion of some of the more experienced users here on the forum.
I am thinking I will use SQL Server Express 2008 R2 on the clients. I would go with compact, but I will most likely have some procedures that the local clients would need.
As always any info is greatly appreciated.
View Complete Post