The article is great the information given is really invaluable for beginner like me, I would need some help from an except like you. Below is the situation in which I need help for you.
I have SQL Server at my Head office in Dubai. We have application built in VB.net; we have our branches at some remote location like Mumbai, sharjah, etc. I need to Synchronized the data between these offices through VPN Connection between offices thought internet. Merged Replication would be type replication I should choose right?
I have triggers on some tables to make the application faster. Would that effect the replication. Or it would only bit slow.? The big doubt I have would this replication would work fine with my clients having MSDE intalled instead of the SQL server. Would it work fine please suggest me the best.
Thanks for the precious time reading this email. Waiting for your reply.