Terminé

Automatic Update from Ms Slq to Mysql (and vice versa) by php script

I need a simple script for update a table content from Ms Sql to My Sql (and viceversa). The content is a product id and quantity

----

Query for take information from Ms Sql

Select

MGGiacDisp.Cd_AR,

sum([login to view URL]) as Giacenza

From

MGDisp('2017') MGGiacDisp

Inner Join AR On MGGiacDisp.Cd_AR = AR.Cd_AR

Inner Join ARARMisura On AR.Cd_AR = ARARMisura.Cd_AR And [login to view URL] = 1

group by MGGiacDisp.Cd_AR

----

Query for take information from MySql

SELECT product_id, quantity FROM oc_product

----

Query for insert into Ms Sql

INSERT into xMagazzino (cd_ar,quantita) values ($product_id, $quantity)

Query for insert into Mysql

UPDATE oc_product SET quantity = $quantity WHERE product_id = $product_id

I found a script that can help you here: [login to view URL]

VERY IMPORTANT ! I can't give you the credential of Ms Sql because i have many customers information of it, and for privacy policy, i can't. I'll test my self you script when is done.

Compétences : MySQL, PHP

en voir plus : php clone mysql database, mysql copy table from one database to another database with data, dbconvert for mssql & mysql, how to copy data from one table to another in mysql using php, sql server to mysql converter, mysql copy table from one database to another different server, php mysql copy table from one database to another, mysql transfer data from one table to another, php script reads excel file inserts data mysql, mysql rss feed php script, import mysql mysql field mapping php script, mysql load database php script, mysql speed test php script, mysql repair table php script, insert data mysql data base php script

Concernant l'employeur :
( 120 commentaires ) Villanova Mondovì, Italy

Nº du projet : #14897995

Décerné à:

hjr122413

Hi Thanks for your posting. I have read your description carefully. I have many experiences in converting the data from MS sql database to mysql database, so if you hire me, I can finish this job perfectly, asap. A Plus

%selectedBids___i_sum_sub_4% %project_currencyDetails_sign_sub_5% EUR en 1 jour
(66 Commentaires)
6.6

23 freelance font une offre moyenne de €142 pour ce travail

mascotindia123

Hey Friend, Myself having has 10 + years experience of web site development. Expert in Custom programming in php / Mysql / Jquery / Wordpress/ Joomla / OSC/ Magento /OpenCart / Android / Mobile development / iPho Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 4 jours
(236 Commentaires)
7.4
langlangFan

Hi, sir. Thanks for your job posting! I am a senior iOS/Android developer with +6 years experience and your project is very interesting for me. I will do my best for your job. Relevant Skills and Experience Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 3 jours
(36 Commentaires)
6.9
hawkscodeaus

Hi, I can start work on your project immediately once you confirm me and i am also open for further discussion if you want. I have 7+ years in web designing & development with good experience in following skills Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 3 jours
(103 Commentaires)
7.4
imagicaworld

Dear Client , We are Really interested to do work with you , We are Web & Software development company having more than 6 year experience in Software development we totally committed to quality service, Transparen Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 3 jours
(71 Commentaires)
6.2
karunakartiwari

Hi, Greeting! Hope you are doing well Please initiate chat to discuss your requirement in [login to view URL] per my understanding we need two script Thanks Karun

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 3 jours
(92 Commentaires)
6.3
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 3 jours
(75 Commentaires)
6.2
polarjin2017

I am from china as a specialist, good in Desktop, Mobile and Website building and 5 years development experience. And I am experienced in Desktop and Web development with Microsoft technologies using C#, WPF , UWP, Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 3 jours
(54 Commentaires)
6.1
abdulghaffar11

Hi, its pretty simple for me but I have few questions to ask, knock me for further discussion, PLEASE DON'T AWARD PROJECT BEFORE DISCUSSION. Thank You!

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 3 jours
(87 Commentaires)
6.3
sunnysmile911

Dear Sir. Do you want to database translation program? I can do it in a day. If you hire me, you can get the high-quality result in the shortest days. Looking forward to a cheerful response. Thanks &Regards, Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 3 jours
(27 Commentaires)
6.3
mamoona016

I am ready to start IMMEDIATELY.I will surely provide you 100% satisfactory work. I have some questions to proceed .Do you have time now ?

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 3 jours
(53 Commentaires)
6.2
suraj2

Hi, I am expert CORE PHP developer having experience of writing on APIs for cross server communication.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 2 jours
(45 Commentaires)
5.6
tsebro

Good day! I'm an experienced database developer. I can update a table content from MsSQL to MySQL. Contact me if you are interested.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 3 jours
(12 Commentaires)
6.0
codingCafe

hi, This is Rahul , i am full time freelance web developer, i will create mysql trigger for you which works automatically without any php script, if can create php script trigger also to complete an existing project! Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 3 jours
(33 Commentaires)
4.7
firozfizz9

You need to update a mysql database by getting data from a ms sql database. Looks like a simple task. I can finish this in a day or two. Please ask any questions in chat.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 3 jours
(16 Commentaires)
4.5
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 0 jours
(14 Commentaires)
4.2
BeautiCG

Hi,dear. We understand your requirements and I am very interested in this job - 'Automatic Update from Ms Slq to Mysql (and vice versa) by php script'. We are senior software developers and I am able to perform this ta Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(15 Commentaires)
4.7
LogicalTec

Hello Sir I have over 7 years of experience with web development using various technologies. I have super vast experience in Database Administration, maintaining complex queries. etc,m > I have another idea about Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 3 jours
(7 Commentaires)
3.7
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 7 jours
(3 Commentaires)
2.6
sarvya521

I am full stack developer. I possess strong knowledge on Database like MySQL, MS SQL Server, Oracle, DB2. I am expert in database desigining, query tunning and database architecture. I assure you that I can complete t Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 3 jours
(3 Commentaires)
2.0
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 3 jours
(6 Commentaires)
1.8