MsACCESS Mysql synchronisation


we are looking for a synchronisation tool from ms access to mysql

Suppose this:

we have a msaccess table with information of users (back end - windows)

we have an online system with a users table in MySQL (linux server). The users table here is part of a large online application

The two tables have different field names, but we are looking for software where we can define (on the linux server with the mysql databases):

a) source table & the connection: use via ODBC this table

b) the target table: compare with this table

c) fields of the source -- fields of the mysql table (left f.e. each field of the source - rigth each field of target that matches with the source label

d) synchronisation direction: in this case: from msaccess to mysql

e) also don't forget that deleted records in the msaccess database should be deleted in the mysql database

f) be aware that the synchronisation may not interrupt the online application

g) volume of users can be 30.000

h) we can use sheduling (cronjob) to launch it regulary, or there should be a script that can be launched manual

i) clear documtation is necessary

Don't waste your time to send a general description of what you can do generally. We're looking for a concrete solution. An example will be expected before we order.

Evner: Databehandling, PHP

Se mere: re label, mysql database application, mysql data access, ms access online, direction software solution, define send, concrete use case, back end tool, online mysql database, may g, Mysql, mysql linux php, concrete, c++ mysql, C# MySQL, c mysql, clear linux, linux cronjob, mysql databases server, php mysql online system

Om arbejdsgiveren:
( 2 bedømmelser ) MELLE, Belgium

Projekt ID: #20282