Sedang Disiapkan

MySQL to legacy file sync

We need to edit some legacy binary files, whose structure are fairly simple (see samples):

- first has 128 bytes per record.

- second has 256 bytes per record.

- live records always start with 00

- deleted records start with 01

- files names may vary and shall not be hard coded.

What we need:

First app:

A windows GUI to manually edit these files: EG delete all marked "to be deleted" records. Basic features: add/search/replace/delete

Second app:

- synchronize these files with a Mysql database. The MySQL tables will be very basic:

- first table: one single field "" or "hostIP"

- second table : 4 fields :email , username, fileref1, filref2.

A windows service that will query a MySQL database and sync (2 ways) with both previous files:

1. Roughly, parse the database and delete/add/replace fields within the bin files. May be a different service for each type of files, thus 2 services ( you may have a different idea). A problem is that I hate the idea of parsing a database that has not been updated. May be the service can receive a "modify" trigger from our PHP app that updates the database. I need expert advice on this one.

2. Update Mysql tables if the binary files have been updated by the legacy app,

3. All records marked for deletion (01 starting byte) will be deleted and synced.

3. Upon editing , a given win32 service shall be restarted, in the local or remote machine.

C/C++/C#/Delphi or even VB


Bidder are requested to specify which resources they might use.

Very Low memory and cpu overhead.

All source code and property rights transfered

Support and debug for 1 year included

File samples :

[url removed, login to view]

[url removed, login to view]

Kemahiran: Pengaturcaraan C, Delphi, Visual Basic, Destop Windows

Lihat lagi: delphi sync mysql, mysql legacy, trigger legacy mysql, what is binary search in c, what is binary search, what is a binary search, visual basic services, synchronize table, starting with visual basic, source code for binary search in c, simple file database, simple binary code, simple binary, search binary, php code search mysql database, php code for property search, names editing,, legacy com, editing service com, code for binary search in c, code for binary search, c code for binary search, c binary search code, binary search source code

Tentang Majikan:
( 24 ulasan ) Paris, France

ID Projek: #364602