Find Jobs
Hire Freelancers

Update Remote MySQL Database table

₹1500-12500 INR

Terminado
Publicado hace alrededor de 7 años

₹1500-12500 INR

Pagado a la entrega
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.
ID del proyecto: 13092357

Información sobre el proyecto

16 propuestas
Proyecto remoto
Activo hace 7 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
Adjudicado a:
Avatar del usuario
Hi Happy to see you back. Ofcourse willing to work in your project and start the work immediately .
₹4.000 INR en 3 días
4,7 (258 comentarios)
6,5
6,5
16 freelancers están ofertando un promedio de ₹5.824 INR por este trabajo
Avatar del usuario
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 en 2 días
5,0 (30 comentarios)
5,9
5,9
Avatar del usuario
I am interested in this job and interested to see the SQL.
₹2.777 INR en 1 día
4,9 (59 comentarios)
5,3
5,3
Avatar del usuario
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 en 1 día
5,0 (15 comentarios)
4,9
4,9
Avatar del usuario
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 en 3 días
4,6 (22 comentarios)
4,4
4,4
Avatar del usuario
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 en 1 día
4,6 (11 comentarios)
4,4
4,4
Avatar del usuario
Hi, I can get this done in 3 days.
₹8.000 INR en 3 días
5,0 (6 comentarios)
3,8
3,8
Avatar del usuario
we can use mysql proxy or send command dirctly to server 2
₹8.888 INR en 5 días
5,0 (4 comentarios)
2,7
2,7
Avatar del usuario
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 en 3 días
5,0 (1 comentario)
1,4
1,4
Avatar del usuario
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 en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I'm a DBA and PL/SQL development. Contact me.
₹1.500 INR en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 3 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de INDIA
DEHRADUN, India
5,0
9
Miembro desde ene 23, 2014

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.