En cours

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.

Compétences : MySQL, PHP

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 :
( 86 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

166 € EUR en 1 jour
(0 Commentaires)
0.0

25 freelance ont fait une offre moyenne de 138 € pour ce travail

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

155 € EUR en 3 jours
(0 Commentaires)
0.0
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

155 € EUR en 1 jour
(0 Commentaires)
0.0
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 en 3 jours
(0 Commentaires)
0.0
suraj2

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

70 € EUR en 2 jours
(0 Commentaires)
0.0
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 en 3 jours
(0 Commentaires)
0.0
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

40 € EUR en 3 jours
(0 Commentaires)
0.0
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

55 € EUR en 3 jours
(0 Commentaires)
0.0
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 en 3 jours
(0 Commentaires)
0.0
josmbogo

I am very familiar with MySql and I understand the time and money it takes to get the job done. I can do it the fastest and for the cheapest

30 € EUR en 1 jour
(0 Commentaires)
0.0
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 Plus

94 € EUR en 3 jours
(0 Commentaires)
0.0
psi19

I do my best to keep prices as low as possible.I ensure you that I will execute your order to you full satisfaction.

30 € EUR en 1 jour
(0 Commentaires)
0.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 en 3 jours
(0 Commentaires)
0.0
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

155 € EUR en 3 jours
(0 Commentaires)
0.0
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

200 € EUR en 3 jours
(0 Commentaires)
0.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

250 € EUR en 3 jours
(0 Commentaires)
0.0
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

250 € EUR en 3 jours
(0 Commentaires)
0.0
100 € EUR en 0 jours
(0 Commentaires)
0.0
100 € EUR en 1 jour
(0 Commentaires)
0.0
200 € EUR en 3 jours
(0 Commentaires)
0.0
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 en 3 jours
(0 Commentaires)
0.0