En curso

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.

Habilidades: MySQL, PHP

Ver más: 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

Información del empleador:
( 86 comentarios ) Villanova Mondovì, Italy

ID de proyecto: #14897995

Adjudicado a:

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 Más

€166 EUR en 1 día
(0 comentarios)
0.0

25 freelancers are bidding on average €138 for this job

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 Más

€155 EUR en 3 días
(0 comentarios)
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 Más

€155 EUR en 1 día
(0 comentarios)
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 días
(0 comentarios)
0.0
suraj2

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

€70 EUR en 2 días
(0 comentarios)
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 días
(0 comentarios)
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 Más

€40 EUR en 3 días
(0 comentarios)
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 Más

€55 EUR en 3 días
(0 comentarios)
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 días
(0 comentarios)
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 día
(0 comentarios)
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 Más

€94 EUR en 3 días
(0 comentarios)
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 día
(0 comentarios)
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 días
(0 comentarios)
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, Más

€155 EUR en 3 días
(0 comentarios)
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 Más

€200 EUR en 3 días
(0 comentarios)
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! Más

€250 EUR en 3 días
(0 comentarios)
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, Más

€250 EUR en 3 días
(0 comentarios)
0.0
€100 EUR en 0 días
(0 comentarios)
0.0
€100 EUR en 1 día
(0 comentarios)
0.0
€200 EUR en 3 días
(0 comentarios)
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 días
(0 comentarios)
0.0