Update existing Windows Service (C#) to sync data between 2 DBs
- or -
Post a project like this€140(approx. $150)
- Posted:
- Proposals: 19
- Remote
- #3963800
- OPPORTUNITY
- Expired
Designer and Developer|WordPress|Shopify|PSD|PHP HTML, JavaScript|WIX| PowerPoint/Keynote| Logo Designing
Berlin
Experienced Full Stack Web and App Developer |Android and IOS App Development| Project Management
London
Python, OpenAI, ChatGPT |Microsoft Fabric| Synapse| SQL Server, Snowflake ❄️, Postgres, MySQL| Power BI, Tableau, Domo | Azure, AWS, GCP| SSIS, Alteryx |AirFlow|AirByte|DBT| DevOps
Bay Minette
38114789594803952393595138429494567942749091273208057274797469848997841827473250427
Description
Experience Level: Entry
Estimated project duration: 1 - 2 weeks
We have an existing Windows Service running (made in C#) making some other tasks. We want to add the option to sync from one source database to another based on a Sync Period Timer and only if newest events got created. Expected Fields to sync are 9 (EventID, Date, Time, LastName, FirstName, Current Date, Current Time, Information1, Information2 ) and of course it could be none, only one or multiple events found inside source DB every time .
What is already working:
We are getting inside the service the local Registry variable fields of the source Database (hostname/port/username/password)
We are getting inside the service the local Registry variables of target Database ((hostname/port/username/password)
We are getting inside the service the local Registry variable of Sync Period Time (i.e. sync every 60sec)
We are getting inside the service the linked Table and Field Names we are interested to sync
(TableName and FieldName of 9 explained Fields)
Every time inside Source Database a new event occurs a new EventID is being Created.
What we need:
1. Make a new SQL connection to source Database every Sync Period Time.
2. Compare the last Event ID, and copy any newest events in the source Database newest events and copy them to the target Database
3. If new event(s) are found, we should also update a defined field inside Windows local Registry with the latest Event ID, Current Time, and Current Date for knowing when the last successful sync was done.
Existing Service is working and doing other tasks and other SQL connection(s) with different timers and different Database , which though are not connected with the current requests.
We are available for any questions and can help you with existing code if you want to use any part of it.
Pretty clear demands and shouldn't take too much time for an experienced programmer to finish.
We have though made a 1-2 weeks available delivery duration but sooner delivery will be appreciated.
Skills in SQL, and C# are demanded for the current project.
What is already working:
We are getting inside the service the local Registry variable fields of the source Database (hostname/port/username/password)
We are getting inside the service the local Registry variables of target Database ((hostname/port/username/password)
We are getting inside the service the local Registry variable of Sync Period Time (i.e. sync every 60sec)
We are getting inside the service the linked Table and Field Names we are interested to sync
(TableName and FieldName of 9 explained Fields)
Every time inside Source Database a new event occurs a new EventID is being Created.
What we need:
1. Make a new SQL connection to source Database every Sync Period Time.
2. Compare the last Event ID, and copy any newest events in the source Database newest events and copy them to the target Database
3. If new event(s) are found, we should also update a defined field inside Windows local Registry with the latest Event ID, Current Time, and Current Date for knowing when the last successful sync was done.
Existing Service is working and doing other tasks and other SQL connection(s) with different timers and different Database , which though are not connected with the current requests.
We are available for any questions and can help you with existing code if you want to use any part of it.
Pretty clear demands and shouldn't take too much time for an experienced programmer to finish.
We have though made a 1-2 weeks available delivery duration but sooner delivery will be appreciated.
Skills in SQL, and C# are demanded for the current project.
Giannis L.
100% (1)Projects Completed
1
Freelancers worked with
1
Projects awarded
9%
Last project
20 Nov 2021
Greece
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies