Find Jobs
Hire Freelancers

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

$10-30 USD

Geschlossen
Veröffentlicht vor etwa 4 Jahren

$10-30 USD

Bezahlt bei Lieferung
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.
Projekt-ID: 24618164

Über das Projekt

12 Vorschläge
Remote Projekt
Aktiv vor 4 Jahren

Möchten Sie etwas Geld verdienen?

Vorteile einer Ausschreibung auf Freelancer

Legen Sie Ihr Budget und Ihren Zeitrahmen fest
Für Ihre Arbeit bezahlt werden
Skizzieren Sie Ihren Vorschlag
Sie können sich kostenlos anmelden und auf Aufträge bieten
12 Freelancer bieten im Durchschnitt $36 USD für diesen Auftrag
Avatar des Nutzers
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 in 7 Tagen
5,0 (34 Bewertungen)
4,8
4,8
Avatar des Nutzers
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 in 1 Tag
5,0 (4 Bewertungen)
4,4
4,4
Avatar des Nutzers
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 in 5 Tagen
5,0 (7 Bewertungen)
4,1
4,1
Avatar des Nutzers
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 in 2 Tagen
5,0 (5 Bewertungen)
3,2
3,2
Avatar des Nutzers
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 in 7 Tagen
5,0 (4 Bewertungen)
2,7
2,7
Avatar des Nutzers
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 in 5 Tagen
5,0 (3 Bewertungen)
1,9
1,9
Avatar des Nutzers
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 in 1 Tag
0,0 (0 Bewertungen)
0,0
0,0
Avatar des Nutzers
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 in 1 Tag
0,0 (0 Bewertungen)
0,0
0,0
Avatar des Nutzers
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 in 2 Tagen
0,0 (0 Bewertungen)
0,0
0,0
Avatar des Nutzers
I Azure SQL Server expert and had done similar work before it will take 1-2 hours to complete this.
$20 USD in 1 Tag
0,0 (0 Bewertungen)
0,0
0,0

Über den Kunden

Flagge von HONG KONG
Hong Kong, Hong Kong
4,9
63
Zahlungsmethode verifiziert
Mitglied seit Mai 20, 2012

Kundenüberprüfung

Danke! Wir haben Ihnen per E-Mail einen Link geschickt, über den Sie Ihr kostenloses Guthaben anfordern können.
Beim Senden Ihrer E-Mail ist ein Fehler aufgetreten. Bitte versuchen Sie es erneut.
Registrierte Benutzer Veröffentlichte Jobs
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Vorschau wird geladen
Erlaubnis zur Geolokalisierung erteilt.
Ihre Anmeldesitzung ist abgelaufen und Sie wurden abgemeldet. Bitte melden Sie sich erneut an.