Find Jobs
Hire Freelancers

Office SQL Server synch with Azure SQL Server script/process/replication

$10-30 USD

Cerrado
Publicado hace alrededor de 4 años

$10-30 USD

Pagado a la entrega
We have an Azure SQL server that has 6 tables, MasterList, Orderlist, Login, Role, Vendor that is mapped to an office sql server that have different fields in different tables. Need a way to synchronize the data across the two databases in an almost real time way. !!!! When bidding on this, please tell me what is a trigger and also your gitlab account (not github) !!! If you don't do that then I know you are not attention detailed enough and I will ignore you.
ID del proyecto: 24618164

Información sobre el proyecto

12 propuestas
Proyecto remoto
Activo hace 4 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
12 freelancers están ofertando un promedio de $36 USD por este trabajo
Avatar del usuario
Hi, Trigger is way to perform any operation (like inserting records etc.) when DML operation is done. I give you gitlab account when we talk. My name is Ali and I can work on it with immediate availability. Let's have quick discussion so I can work on it.
$20 USD en 7 días
5,0 (34 comentarios)
4,8
4,8
Avatar del usuario
Greetings, I'm professional database and BI expert with 12+ years experience. Currently I'm working as Senior DW, BI & DB developer in one of the leader financial corporation. As you can see in my profile page, I have a deep experience of database related projects. I'm top expert. -- Best regards, Davit Dartsimelia Senior BI & SQL Developer
$56 USD en 1 día
5,0 (4 comentarios)
4,4
4,4
Avatar del usuario
hi, a trigger is an event that fire an action. The event could take place a database level or table level.I don't have Gitlab account. I am a SQL Server expert and I could suggest more options to have the results
$56 USD en 5 días
5,0 (7 comentarios)
4,1
4,1
Avatar del usuario
Trigger is a code which executed automatically when predefined event like ddl, dml is fired I  have more then 15 years of experience in SQL Server databse development and Administration. I have worked with medium to large mission critical databases. Worked for database design and performance tuning. I am also good for BI part like SSIS, SSRS and SSAS. I can work in any time zone I am immediate available to join. 
$111 USD en 2 días
5,0 (5 comentarios)
3,2
3,2
Avatar del usuario
Dear Prospect Hiring Manager, After a full understanding of your project description, I can say I could help you with strong interests and desire. I am a serious bidder here and i have already worked on a similar project before and can deliver as u have mentioned I have the skills you've mentioned Some skills are : HTML / CSS / JavaScript / Jquery / PHP / CI / Laravel / Asp.Net MVC / Core / Web APIs / Microsoft Azure If you allow me to help you, I'd be honored, and I'll put all my energy and time on this project from now. I hope to hear from you soon. Thank You,
$20 USD en 7 días
5,0 (4 comentarios)
2,7
2,7
Avatar del usuario
Dear employer, With your requirement, if you want to use trigger, you have to define at least 6 triggers for insert, 6 for delete and 6 for update to sync data whenever the data changed. Notes: to archive your goal, we also need to create linked server to execute query remotely. I'm thinking for another solution. Please contact me then we can have detail discussion before make decision. Thanks
$30 USD en 5 días
5,0 (3 comentarios)
1,9
1,9
Avatar del usuario
Dear Bid Poster, Thank you for the opportunity to place the Bid on your Project. After reviewing the job description, it’s clear that you’re looking for a candidate that is extremely familiar with the responsibilities associated with the Sr. Software Engineer role and can perform them confidently. Given these requirements, I am certain that I have the necessary skills to successfully do the job adeptly and perform above expectations. Thanks, Naeem Ahmed
$25 USD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hello, I don’t use gitlab, i’m new to this. A trigger is a stored procedure that initiate an action when an event insert/update/delete occurs. If you need to sync data from azure db to on prem sql server you can use DATA SYNC with some limitations (max 500 tables, and some specific data conntent) it can run as fast as min 5 min delay. If you need to sync from on prem to Azure Db then you can use normal transactional replication, azure db can be a subscription to a publication on prem. Have a nice day, hope this helps you.
$10 USD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I have good knowledge in ms sql development and administration., and having 9 years experience in IT. by using trigger (after insert, update and delete) can apply same changes from one to another db with the support of linked server connection between these two servers.
$30 USD en 2 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I Azure SQL Server expert and had done similar work before it will take 1-2 hours to complete this.
$20 USD en 1 día
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de HONG KONG
Hong Kong, Hong Kong
4,9
63
Forma de pago verificada
Miembro desde may 20, 2012

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.