Sedang Disiapkan

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.

Kemahiran: MySQL, PHP

Lihat lebih lanjut: 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

Tentang Majikan:
( 81 ulasan ) Villanova Mondovì, Italy

ID Projek: #14897995

Dianugerahkan kepada:

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 Lagi

€166 EUR dalam sehari
(13 Ulasan)
4.5

26 pekerja bebas membida secara purata €139 untuk pekerjaan ini

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 Lagi

€200 EUR dalam 4 hari
(204 Ulasan)
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 Lagi

€155 EUR dalam 3 hari
(31 Ulasan)
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 Lagi

€200 EUR dalam 3 hari
(54 Ulasan)
6.7
karunakartiwari

Hi, Greeting! Hope you are doing well Please initiate chat to discuss your requirement in details.as per my understanding we need two script Thanks Karun

€222 EUR dalam 3 hari
(64 Ulasan)
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 dalam 3 hari
(87 Ulasan)
6.2
suraj2

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

€70 EUR dalam 2 hari
(45 Ulasan)
5.6
€155 EUR dalam 3 hari
(55 Ulasan)
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 dalam 3 hari
(23 Ulasan)
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 Lagi

€94 EUR dalam 3 hari
(19 Ulasan)
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, Lagi

€250 EUR dalam 3 hari
(15 Ulasan)
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 dalam 3 hari
(2 Ulasan)
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 Lagi

€150 EUR dalam 3 hari
(13 Ulasan)
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, Lagi

€155 EUR dalam 3 hari
(6 Ulasan)
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 Lagi

€155 EUR dalam sehari
(9 Ulasan)
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 dalam 3 hari
(14 Ulasan)
4.0
€100 EUR dalam 0 hari
(8 Ulasan)
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! Lagi

€250 EUR dalam 3 hari
(9 Ulasan)
3.0
€200 EUR dalam 3 hari
(6 Ulasan)
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 Lagi

€40 EUR dalam 3 hari
(2 Ulasan)
1.3
€152 EUR dalam 7 hari
(0 Ulasan)
0.0