Join us at the AVASOFT + Microsoft Tech Summit 2024 on Sep 12 | Microsoft Technology Center | Malvern, PA Join us at the AVASOFT + Microsoft Tech Summit 2024 on Sep 12 | Microsoft Technology Center | Malvern, PA Join us at the AVASOFT + Microsoft Tech Summit 2024 on Sep 12 | Microsoft Technology Center | Malvern, PA
Join us at the AVASOFT + Microsoft Tech Summit 2024 on Sep 12 | Microsoft Technology Center | Malvern, PA

Database synchronization using Microsoft Sync framework

Client is a leading manufacturer of disassembling, recycling of precision cutting, grinding and polishing mechanical equipment.
Reading time: 2 min(s)

They offer service of equipment at the client place. Our client value represents the corporate philosophy that identifies the ideal from various perspectives, including the direction in which the company should progress.

Business Challenge

  • Lotus notes based application need to be upgraded to new technology stack.
  • The organization was using a Lotus notes based application that needs to be upgraded to new technology stack.
  • New business has constraint for service engineers to work from remote areas that lacked internet facility.
  • The new application has to be support both online and offline mode.

How Avasoft Helped?

We provide different types of Databases to the client.

  • AVASOFT proposed the solution to sync different types of database to the client.
  • Analysed the existing framework which suits their requirement. Planned a road map to synchronize the component database with existing sync architecture.
  • Designed metadata and built the reports using sync framework 2.1. Achieved one way & two way synchronization.
  • Tested with the sample application for synchronizing the data from source to its destination database (i.e., SQL Server to SQL Express).

Teck Stack

sync
MS_SQLServer2012-8
casestudies_sqlserver
Microsoft
ssrs_logo
Casestudies_HTML5-1
Casestudies_CSS3-1

Value Additions To Customer

We migrate the existing site to Telerik Components

  • Customer no longer requires to have a constant network connection to access their information.
  • Our consulting inputs during requirements phase helped customer obtain a new version that addressed existing issues.
  • Built sophisticated reports using SSRS that improved decision making.

Business Gain

Our efficiency reflects as business gains.

  • Service Engineers can add details from client location off-line.
  • Optimal allocation mode of engineers to different clients within the same region.
  • Time sheet entry and tracking.
  • Interface to invoicing system.
  • Improved communication with clients.

Business Need

We grasp your needs quickly

  • To track services done by Service Engineers for clients of various regions.
  • To track different machineries associated with the service request.
  • Manage service details of various client locations through online and/or offline modes.
  • Improve service efficiency.
  • Improve customer and service engineer communication

Share this Article