Update existing Windows Service (C#) to sync data between 2 DBs

140.0 EUR

140.0 EUR peopleperhour 技术与编程 海外
337天前

详细信息

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 Database3. 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.

免责声明

该外包需求信息来源于站外平台,本站仅提供公开信息部分字段展示与订阅服务,更多请查看免责声明

关注公众号,不定期副业成功案例分享
关注公众号

不定期副业成功案例分享

领先一步获取最新的外包任务吗?

立即订阅

类似推荐