Sync mysql and mssql developed in PHP

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.

Skills: PHP, MySQL, SQL, Software Architecture, Microsoft SQL Server

See more: run multiple mysql database queries php send xml, export mysql excel using php, convert php mysql mssql, transfer data from sql server to mysql using ssis, mysql data migration tool, sql server to mysql tool, sync mssql to mysql, convert mssql to mysql free online, convert ms sql dump to mysql, mysql to sql server replication, mysql to sql server converter free download, php mysql find next available voucher number, convert asp mssql site php mysql, php phone number mysql, mysql mssql php sync odbc, sync script mssql php, crm developed php mysql demo, joomla mysql mssql php access violation, site developed php mysql, sync mysql mssql joomla

About the Employer:
( 0 reviews ) Lima, Peru

Project ID: #27486211

22 freelancers are bidding on average $497 for this job


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 More

$750 USD in 22 days
(97 Reviews)

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: This is a placehoolder bid, I would be More

$500 USD in 7 days
(87 Reviews)

Hi! Your project caught my interest. First let me quickly introduce myself. My name is Kanika, and I am a Website Developer .I only bid on jobs I am 100% confident I can complete on time & on budget.. I am Good at MySQ More

$530 USD in 28 days
(71 Reviews)

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 More

$1200 USD in 25 days
(49 Reviews)

Hello? I have worked on php, ajax, jquery with API(AWS, shopify, wordpress etc...) Integration, Admin template projects to what you are looking for, and I am confident I can exceed your expectations. I have attached More

$555 USD in 10 days
(27 Reviews)

Hi, Thanks for your job posting and I have interested in your project. I’m a full-stack developer who has enough skills to complete this project. I have strong experience in Automation, GUI application, Scraping & Cra More

$500 USD in 7 days
(10 Reviews)

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 More

$500 USD in 7 days
(6 Reviews)

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 More

$500 USD in 3 days
(19 Reviews)

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 More

$500 USD in 7 days
(16 Reviews)

Hello, I have read your project details. As I am a PHP and MySQL expert, I am confident about your project and I can make it perfect. I have rich experience with 7+ years I am ready for you and I can start immediately. More

$500 USD in 7 days
(10 Reviews)

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 More

$250 USD in 7 days
(6 Reviews)

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.

$400 USD in 7 days
(3 Reviews)

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 More

$500 USD in 7 days
(2 Reviews)

Hello! Thanks so much for your job posting I am a Professional for the PHP & MySQL,Angular, Html,JavaScript,JQuery/ajax,CSS and Bootstrap. And I have special technoloy like ceo,good communication skill,quick response. More

$500 USD in 7 days
(6 Reviews)

Hello, sir. I carefully read your job description and it appeals me so much. As a professional web developer , I have clean code style and experiences to develop web sites with WordPress, Laravel, React.js and so on. More

$300 USD in 7 days
(6 Reviews)

----------I can help you__________ I'm php expert that have 4+ years. I have 4+ years development course, I have gotten many experiences. If you hire me,I am ready to work according to your work time. If you want I ca More

$500 USD in 7 days
(2 Reviews)

Hello! We are ready to take up this task! I am ready to discuss details and deadlines based on the cost starting with $12 per hour. We could make a detailed calculation if you are interested in our offer after you giv More

$500 USD in 7 days
(1 Review)

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 More

$500 USD in 7 days
(1 Review)

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 More

$389 USD in 7 days
(8 Reviews)

hi there! we believe we can design a website to meet your ultimate requirements, Not sure what exactly would be good for your business? we have experts from every fields ready with your answer Please contact us 24/7 More

$250 USD in 2 days
(0 Reviews)