The objective of this application is to synchronice two databases: ODBC and Mysql.
The first database (ODBC) is located in our customer facilities with a regular internet connection (dynamic ip) and there's no mayor IT structure, because is just a small business LAN. One PC has the database (ODBC: DBF), where a desktop software storage it's data. Developer can add fields to tables but cannot modify the database structure nor delete fields.
The second database (Mysql) is located in a web server inside a datacenter, which runs Linux with Apache, PHP and Mysql. When dbsyncapp is installed, it creates a copy of the customer database and the migrate all records.
The migration must be done sending a sha1 encoded XML file to a PHP file in the web server. The PHP must decode the file, validate data integrity and write in the Mysql database. In case of error, the error message must be copied to the error log.
When a record has been modified in any of the two databases, the application must replicate the update in the other database.
The dbsyncapp must have a password protected control panel, where user can:
- define connection data to the remote host (host, database, user, password).
- define which tables to sync.
- define local database user and password when needed.
- Access error and execution logs.
- add/modify/delete users.
Some facts:
- the two databases exists and we can provide examples of both.