Update Remote MySQL Database table

₹1500-12500 INR

Completed

Posted

about 7 years ago

₹1500-12500 INR

Paid on delivery

Hello, We have an application (APP-1) written in VB.Net with MySQL DB (DB-1), hosted on Windows 2008 R2 (Server - 1, IP-1). There is another application APP-2, in PHP with MySQL DB (DB-2), hosted on Linux machine (Server - 2, IP - 2) APP-1, gets regular hits from client applications and there is 1 particular field in Table-1 which gets updated/changed over time (Field Name is "IP-Address" - ip of client). Now this particular field is also there in DB-2 (Table - 2) called "IP". There is code which manages this field in DB-1 and updates accordingly using Stored procedures. We want that as soon as Field-1 in Table-1 gets updated, simultaneously Field-1 in Table-2 also gets updated.

Project ID: 13092357

About the project

16 proposals

Remote project

Active 7 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@gkalish

Hi Happy to see you back. Ofcourse willing to work in your project and start the work immediately .

₹4,000 INR in 3 days

4.7

(258 reviews)

6.5

16 freelancers are bidding on average ₹5,824 INR for this job

@romanapanovich

Hello I can write it via using one of two methods 1- when there is updated this value in first table- the corresponding soft can send a request to php with updated value and php will update it 2- via CRON some additional php script will look at value on table 1 and uodate it on table2 (every minute for example) preferreble is 1st method but Im not sure in it

₹5,600 INR in 2 days

5.0

(30 reviews)

5.9

@ripasahasl

I am interested in this job and interested to see the SQL.

₹2,777 INR in 1 day

4.9

(59 reviews)

5.3

@MuhammadRohailP

Hello, This is simple task, I will create a replication script for you for this field. It wil work perfectly, as per your requirement.

₹1,500 INR in 1 day

5.0

(15 reviews)

4.9

@huongth

Hi. I am an expert in VBA, VBScript, Visual Basic, C#, Java, ASP, ASP.NET, Access, MySQL, MSSQL, QuickBooks, Oracle. I can create auto scripts to scrape websites, auto click, format txt, csv, xls, xlsx, doc, docx, json, xml, database files as you request. I can start right now

₹3,000 INR in 3 days

4.6

(22 reviews)

4.4

@GameHackerPM

Hi, I'm Ahmed. I just saw your request and understood that you want to make once you change a field in a table, it should also gets updated on another table with the same data (IP - Address => IP). I provide you full support until you confirm that you got it working as well as you would like it to be. We can also make sure that I understand it as well as you think I got it through Chat. I already worked with MySQL for more than 7 years, it was beside coding to be honest, but got enough knowledge to handle your request. Thanks for your attention! :)

₹7,500 INR in 1 day

4.6

(11 reviews)

4.4

@enterpriseit1

Hi, I can get this done in 3 days.

₹8,000 INR in 3 days

5.0

(6 reviews)

3.8

@HDDevelopment

we can use mysql proxy or send command dirctly to server 2

₹8,888 INR in 5 days

5.0

(4 reviews)

2.7

@pnlsystemssales

Hi, We can do it in 3 days if we can get access to the servers. This helps us in providing ideal solution as well as good validation.

₹7,777 INR in 3 days

5.0

(1 review)

1.4

@AlbertKihm

I have 7+years experiences with PHP,MySQL,web design. I can complete your project at a time perfectly. Also if you hire me, I will offer several suggestions to make your project more complete. Thanks.

₹6,172 INR in 1 day

0.0

(0 reviews)

0.0

@luanmazevedo

I'm a DBA and PL/SQL development. Contact me.

₹1,500 INR in 1 day

0.0

(0 reviews)

0.0

@mysqldbhelp

Hi, I have a strong experience in MySQL database. I can get this task done. It can be done by setting up a replication between both databases to make the data in sync.

₹7,777 INR in 3 days