I'm quite new to SQL and need some assistance?
Our company uses software at branch level that communicates from an access db to a SQL db located at the HQ of this company.(Note there are more than 100 branches that will be communicating to the HQ, average db size 150Mb)
We are looking at redeveloping this software to use SQL at branch level. What we eventually would like to have is the branch db replicated to the HQ server using linked SQL. I know that this is possible, but am not sure of the actual details involved!
Am I correct in assuming that I could possibly create a VPN from the branch to the HQ, applying linked SQL through the VPN. The re-developed software will then be transfering/replicating data through the VPN tunnel using the Linked SQL.
Any help would be appreciated.
View Complete Post