Sync mysql and mssql developed in PHP

Zaprto Objavljeno pred 3 letoma/leti Plačilo ob prevzemu
Zaprto Plačilo ob prevzemu

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.

PHP MySQL SQL Arhitektura porgramske opreme Microsoft SQL strežnik

ID projekta: #27486211

Več o projektu

15 predlogov Oddaljen projekt Aktiven pred 3 letoma/leti

15 freelancerjev ponuja v povprečju za $511 na tem delu

AwaisChaudhry

Hello,I have read the job description and I am interested in this job. I have 8 years experience in developing products using PHP, SQL, Microsoft SQL Server, MySQL and Software Architecture. I have read your requiremen Več

$750 USD v 22 dneh
(101 ocen)
8.0
extreamcode

HI, I can assist you with Sync mysql and mssql developed in PHP . Here is a sampling of the few of my work contained at my portfolio: https://www.freelancer.com/u/extreamcode.html This is a placehoolder bid, I would be Več

$500 USD v 7 dneh
(93 ocen)
7.9
stepinnsolution

Hi sir, i have read your all requirement and I understand what you nedd. we can do everything in your project what you want because we are running well reputed company and we have 27 developer in house feel free to con Več

$1200 USD v 25 dneh
(57 ocen)
7.2
vovakovalkov80

Hello I am interested in your project as a web developer with 10+ years of experience. I can give you the perfect result in your timeline. If you award me the project I'd be very happy to discuss this further and get s Več

$500 USD v 7 dneh
(11 ocen)
5.3
nizamfarhas

Hello Hope you are doing well. I checked your description "Sync mysql and mssql developed in PHP". I'm a senior PHP developer with 9 years of experience. I will deliver you great result asap. If you check my portfolio Več

$500 USD v 3 dneh
(23 ocen)
5.5
hassansystem

EXPERT with PHP & Databases I have 8+ years of experience in Web Designing and Development. Let have a chat and discuss in detail I have read your description. Once we clear our requirements and understood all things Več

$500 USD v 7 dneh
(18 ocen)
4.8
Petrov4work

Hello! How are you? I'm Anton Petrov live in Russia and Full-Time Individual Developer. I am a dedicated and hard working person who believes in honesty and good working relation. I have extensive experience building Več

$250 USD v 7 dneh
(6 ocen)
4.1
bogdandem12

Dear client, Yes, I can make script using both "php client" and "php server". Could you share your designs now? Could you send me exact to-do list so I can estimate timeline? We can discuss more details via chat. Thank Več

$500 USD v 7 dneh
(2 ocen)
2.9
ivanrogov53

Hi there. I read your proposal very carefully and I could understand your requirement in short time becaues I have rich experience in PHP development. I am not going to use any frameworks or plugins as you wish and I w Več

$500 USD v 7 dneh
(1 Ocena)
2.2
ShubhamScrystal8

Hello There, I have seen the details as you need. It's a good place for work and we can communicate then making a good deal. Please send me a first message I could drop some samples of my past work to get more confid Več

$389 USD v 7 dneh
(9 ocen)
1.7
hsvotwa

We have great experience in MSSQL, MySQL and PHP - as well as vast experience in DB performance optimization for huge datasets.

$400 USD v 7 dneh
(0 ocen)
0.0