Synchronising data b/w MS-Access & SQL Server

  • Thread starter Thread starter Qazi
  • Start date Start date
Q

Qazi

I have multiple sites where standalone MS-Access database are running
at different demographic locations (which some VB application is
accessing), what i want is that the data from these sites are copied
to some centralized location by any means (i've to make a daemon for
this purpose which didn't interfere with the VB application which is
accessing MS-Access database) where i'll be able to take some
decisions/statistics/etc ... I need a programmatic solution for this
approach, can any of you tell me the way with which I can do so?

any response is highly appreciated, Thanks.
 
You should take a look at the several data replication patterns and choose
the one that best fit your requirements. Also what about security, is there
a VPN connection or do you need to encrypt streams? Do you need to
synchronize hourly, daily, weekly? How much data will be sent over the wire
during each synchronization?

Gabriel Lozano-Morán
 
Back
Top