Microsoft Access to SQL Server - synchronization
- by David Pfeffer
I have a client that uses a point-of-sale solution involving an Access database for its back-end storage. I am trying to provide this client with a service that involves, for SLA reasons, the need to copy parts of this Access database into tables in my own database server which runs SQL Server 2008. I need to do this on a periodic basis, probably about 5 times a day. I do have VPN connectivity to the client.
Is there an easy programmatic way to do this, or an available tool? I don't want to handcraft what I assume is a relatively common task.