Project Description:
Synchronisation of 2 or more servers through webservices based on Soap.
The merces server is usually on a central server on the web.
The local systems communicate with the server through SOAP port 80 or 443
For offline purposes we need a local server, that synchronizes with the central server.
This synchronisation must be customizable and work in both directions for in-serts, updates and deletes or mark as deleted.
Following issues have to be mentioned:
Tablelist with all needed parameters
Event triggered or scheduled execution
Abstraction of the structures: building sql-statements automatically from ta-bledefs
Key constraints: how to prevent them?
Delta synchronization: timestamp/flag criteria
Security: authentication before execution
Load: packages of data for big tables.
Protokoll: SOAP, JSON, others?
The list of tables contains all common tables of the involved databases (about 150 tables).
The datamodel of the involved databases is congruent.
There are no key restrictions to observe
The sql statements are build automatically with tablename, fieldlist observing excluded fields, wherecondition
There is a configuration table with all tables and all needed information
The conditions are stored in a table like this:
tablename
fieldlist (read from tabledef?)
fields_excluded
direction: 1>2, 1<2, 1<>2
triggers: timestamp, recordcount,
whereCondition
Type: insert before update, update before insert, only insert, only update
LastRun
