Challenge
The customer needed a desktop application that, by connecting to an external database, makes possible to detect the changes that have occurred in a series of fields in a given period, as well as download these changes to a spreadsheet.
The application must be multilingual and the period will be selectable through filters.
The challenge was that it is an incremental database of more than 50 million records.
Solution
We have developed a desktop application using Visual Studio. Due to the large volume of the database, the solution generates a replica of the database in a local environment to speed up the reading and / or writing of the information. The data is imported daily to the local database, this activity being transparent for the client. The solution includes the possibility of exporting the data to the customers Excel template.
Features
Visual Studio with C# language
MySQL database