Microsoft Access to SQL Server - synchronization

Posted by David Pfeffer on Stack Overflow See other posts from Stack Overflow or by David Pfeffer
Published on 2010-04-21T15:58:43Z Indexed on 2010/04/21 16:23 UTC
Read the original article Hit count: 233

Filed under:

synchronization

|

access

|

sql-server

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.

© Stack Overflow or respective owner

Related posts about synchronization

Thread Synchronization and Synchronization Primitives

as seen on DotNetBlocks - Search for 'DotNetBlocks'
When considering synchronization in an application, the decision truly depends on what the application and its worker threads are going to do. I would use synchronization if two or more threads could possibly manipulate the same instance of an object at the same time. An example of this in C# can… >>> More
Inner synchronization on the same object as the outer synchronization

as seen on Stack Overflow - Search for 'Stack Overflow'
Recently I attended a lecture concerning some design patterns: The following code had been displayed: public static Singleton getInstance() { if (instance == null) { synchronized(Singleton.class) { //1 Singleton inst = instance; //2 if (inst == null) { … >>> More
SugarSync: Online Backup and Synchronization

as seen on Internet.com - Search for 'Internet.com'
Despite a few flaws, SugarSync offers small businesses a way to synchronize files across multiple computers and smartphones. Plus, it includes online data backup. >>> More
SugarSync: Online Backup and Synchronization

as seen on Internet.com - Search for 'Internet.com'
Despite a few flaws, SugarSync offers small businesses a way to synchronize files across multiple computers and smartphones. Plus, it includes online data backup. >>> More
Send regular keyboard samples OR keyboard state changes over network

as seen on Game Development - Search for 'Game Development'
Building a multi player asteroids game where ships compete with each other. Using UDP. Wanted to minimize traffic sent to server. Which would you do: Send periodic keyboard state samples every from client every to match server physics update rate e.g. 50 times per second. Highly resilient to packet… >>> More

Related posts about access

Postgres user drop

as seen on Stack Overflow - Search for 'Stack Overflow'
I am trying to drop a user: drop user testUser; I want to force this to work in a simple manner (Not a million calls)... How can I do this easily? I get this output: ERROR: role "testUser" cannot be dropped because some objects depend on it DETAIL: access to table main.tap_db_version access… >>> More
Postgres user/role drop

as seen on Stack Overflow - Search for 'Stack Overflow'
I am trying to drop a user: drop user testUser; I want to force this to work in a simple manner (Not a million calls)... How can I do this easily? I get this output: ERROR: role "testUser" cannot be dropped because some objects depend on it DETAIL: access to table main.tap_db_version access… >>> More
ASA hairpining: I basicaly want to allow 2 spokes to be able to communicate with each other.

as seen on Server Fault - Search for 'Server Fault'
ASA Spoke to Spoke Communication I have been looking at spke to spoke comms or "hairpining" for months and have posted on numerouse forums but to no avail. I have a Hub and spoke network where the HUB is an ASA Firewall version 8.2 * I basicaly want to allow 2 spokes to be able to communicate with… >>> More
.NET Access automation with Access 2007 Runtime

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm having trouble deploying .NET application which uses Microsoft Access automation. I've installed the Access 2007 Runtime and Primary Interop Assemblies (PIAs) on the target machine: Access 2007 Runtime Office 2007 PIAs However, when I try to create the ApplicationClass: Application access… >>> More
Cisco 800 series won't forward port

as seen on Server Fault - Search for 'Server Fault'
Hello ServerFault, I am trying to forward port 444 from my cisco router to my Web Server (192.168.0.2). As far as I can tell, my port forwarding is configured correctly, yet no traffic will pass through on port 444. Here is my config: ! version 12.3 service config no service pad service tcp-keepalives-in service… >>> More