Käynnissä

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([url removed, login to view]) 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 [url removed, login to view] = 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: [url removed, login to view]

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.

Taidot: MySQL, PHP

Näytä lisää: 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

About the Employer:
( 83 reviews ) Villanova Mondovì, Italy

Projektin tunnus: #14897995

Myönnetty käyttäjälle:

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 Lisää

166 € EUR 1 päivässä
(13 arvostelua)
4.5

26 freelanceria on tarjonnut keskimäärin 139 € tähän työhön

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 Lisää

200 € EUR 4 päivässä
(204 arvostelua)
7.2
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 Lisää

155 € EUR 3 päivässä
(31 arvostelua)
6.7
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 Lisää

200 € EUR 3 päivässä
(54 arvostelua)
6.7
karunakartiwari

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

222 € EUR 3 päivässä
(64 arvostelua)
6.0
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!

100 € EUR 3 päivässä
(87 arvostelua)
6.2
suraj2

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

70 € EUR 2 päivässä
(45 arvostelua)
5.6
155 € EUR 3 päivässä
(55 arvostelua)
5.8
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 ?

155 € EUR 3 päivässä
(23 arvostelua)
5.5
harshalchaudhari

I am interested in working on your project. I have a team of developers and designers who expertise in web development and designing. We have done similar projects and have received immense credits for the same. Our de Lisää

94 € EUR 3 päivässä
(19 arvostelua)
5.4
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, Lisää

250 € EUR 3 päivässä
(15 arvostelua)
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.

210 € EUR 3 päivässä
(2 arvostelua)
4.5
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 Lisää

150 € EUR 3 päivässä
(13 arvostelua)
4.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, Lisää

155 € EUR 3 päivässä
(6 arvostelua)
3.9
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 Lisää

155 € EUR 1 päivässä
(9 arvostelua)
3.8
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.

60 € EUR 3 päivässä
(14 arvostelua)
4.0
100 € EUR 0 päivässä
(8 arvostelua)
3.5
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! Lisää

250 € EUR 3 päivässä
(9 arvostelua)
3.0
200 € EUR 3 päivässä
(6 arvostelua)
2.2
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 Lisää

40 € EUR 3 päivässä
(2 arvostelua)
1.3
152 € EUR 7 päivässä
(0 arvostelua)
0.0