I need an application to be developed in "PHP Client" and a "PHP Server".
The client application must be used from many computers, all computers will have an MSSQL database installed, which, with the "PHP client" application, must send its structure and information through a web service to the "PHP Server"
In "PHP Server" upon receiving the information, it must analyze if there are new fields and lengths of the data type, if so, the destination database must be modified, which will be MySQL, and then save the received data when it is modified correctly the structure.
Obviously, as the clients will have MSSQL and the MySQL server, then the server will have to rename each database with an identifier that can be obtained from a specific table in the client's database.
It is also required that the data travel compressed to facilitate sending by blocks and that after sending a block it is possible to confirm the saving on the server, to avoid missing.
We also need another independent process that when it is executed 1 time a day, compares if there are changes in the data that are in the last records of the month, if changes are found, they must be saved in the same MySQL table but they will have to be added by a record plus which will have to be differentiated by a correlative number, to know on the server which record has been modified and that the update date of that record is saved.
And as a last indication, we require that in a field in a totally separate table, a file that is on each client computer be synchronized, which is an XML file that is saved on the client, if it does not exist, that it looks for it once a day , a maximum of one month old.
Try to only use bootstrap so that the application load on the Client PC is light.
And think about it so that it does not hang on the server when receiving data from 300 computers simultaneously.
Do not have to install additional or plugins, only pure PHP code, preferable that runs in XAMPP and not add more configurations, or odbc.
22 pekerja bebas membida secara purata $497 untuk pekerjaan ini
Hi, I am a senior developer. I have read your requirement specially. I want to show my skill. You may be amazed at my skill. Please drop a message for further discussion. Thank you.