End Google Ads 201810 - BS.net 01 --> Dear All, c# and SQL Guys.
we are working in Distributed envoirnment, we have got 34 remote office and 1 HQ,
each remote office runs access application with c# as frondend and HQ runs SQL 2005.
well, i have created a service in remotes office which gets any newly record from .mdb file and then creates an xml file of that, then sends this xml to remote FTP.
from HQ another service runs which gets those xml files from FTP and then manipulates those statements against our HQ database.
we have made replication between our HQ and WEb SERVER which both runs SQL 2005. Replication works perfect.
creating xml from remote office are perfect, downloading and executing them against HQ Database is again perfect.
i have a question
1. I want to get newly records from HQ and WEB SERVER and then these records should be in remote office "what method u guys recommend?"

we have also web application which is connected to WEB SERVER

I would really ur ideas and also their benefits with drawback

Abdul Rahaman Hamidy
Database Developer
Kabul, Afghanistan