Ditutup

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.

Kemahiran: PHP, MySQL, SQL, Kejuruteraan Perisian, Pelayan Microsoft SQL

Lihat lagi: 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

Tentang Majikan:
( 0 ulasan ) Lima, Peru

ID Projek: #27486211

22 pekerja bebas membida secara purata $497 untuk pekerjaan ini

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 Lagi

$750 USD dalam 22 hari
(97 Ulasan)
7.9
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 Lagi

$500 USD dalam 7 hari
(87 Ulasan)
7.7
kanika6665

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 Lagi

$530 USD dalam 28 hari
(71 Ulasan)
6.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 Lagi

$1200 USD dalam 25 hari
(49 Ulasan)
6.1
nemanjadj20

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 Lagi

$555 USD dalam 10 hari
(27 Ulasan)
5.7
arturkandalyan

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 Lagi

$500 USD dalam 7 hari
(10 Ulasan)
5.3
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 Lagi

$500 USD dalam 7 hari
(6 Ulasan)
4.9
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 Lagi

$500 USD dalam 3 hari
(19 Ulasan)
5.4
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 Lagi

$500 USD dalam 7 hari
(16 Ulasan)
4.6
miroslave2020

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. Lagi

$500 USD dalam 7 hari
(10 Ulasan)
4.1
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 Lagi

$250 USD dalam 7 hari
(6 Ulasan)
4.0
ssagaydachniy

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 dalam 7 hari
(3 Ulasan)
3.9
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 Lagi

$500 USD dalam 7 hari
(2 Ulasan)
2.9
Raspizdaiy

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. Lagi

$500 USD dalam 7 hari
(6 Ulasan)
2.8
strop55golf

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. Lagi

$300 USD dalam 7 hari
(6 Ulasan)
2.7
Larisawebdev

----------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 Lagi

$500 USD dalam 7 hari
(2 Ulasan)
2.7
evgeniyseogr

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 Lagi

$500 USD dalam 7 hari
(1 Ulasan)
2.0
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 Lagi

$500 USD dalam 7 hari
(1 Ulasan)
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 Lagi

$389 USD dalam 7 hari
(8 Ulasan)
1.7
aamiranwar33

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 Lagi

$250 USD dalam 2 hari
(0 Ulasan)
0.0