I have an existing Firebird 3.0 SQL database project written in Delphi.
I need a tool (.exe and Delphi source code) which can do a two-way synchronization of data in certain tables on my website and on my local database.
1) Upload selected records from the local Firebird SQL database into a table of the MySQL database of my website. There are some related tables which need to be synchronized as well.
2) Download all records from the MySQL database on my website into the tables of my local database. (again there are some related tables which need to be synchronized as well.). Changes made online have precedence, i.e. overwrite data in the MySQL table (but only for the records which we are synchronizing).
3) One-way sync of a few helper tables on the MySQL database with data from some helper tables of the FIrebird database (overwriting all data online and deleting dropped fields)
GUI: Simple GUIL
Button "Sync helper table" to perform the upload mentioned in 3) above.
Button "Download Data" to perform the download mentioned in 2) above.
Button "Upload Data" to perform the upload mentioned in 1) above
Combobox "Custom Tag", which displays [url removed, login to view] values (CUSTOM_TAGS is a table on my local database). Upload of all records which carry the selected tag through table PARTNERS_CUSTOM_TAGS (This table allows the user to link one PARTNERS record with several CUSTOM_TAGS records).
Please use FireDAC (mandatory).
I want to buy work directly from someone who has already done it
11 freelancers are bidding on average $210 for this job
dear Im adelphi developer I read your job description, I understand your requirements, I need to share me more details about your project waiting your reply