Table of Contents
Data Archiving Solution Case Study | milkrite | InterPuls
The Issue
Throughout 130 years, milkrite | InterPuls have supported farms with exceptional research and development of innovative systems.
In early 2022, they reached out for the support and expertise of WellData, requesting an appropriate data archiving solution for their manufacturing system.
The Challenge
Milkrite | InterPuls required a data archiving solution to complement their new manufacturing system, which stored data using a SQLite database.
To maintain performance, data needed to move from SQLite to a SQL Server database for reporting purposes.
Subsequently, data also needed to be deleted from SQLite, which was handled by the third party who provided the client with the system.
The Solution
WellData liaised closely with the client and manufacturing provider to create a data archiving solution that met the requirements of both parties.
- Archive new data on a schedule
- Delete only successfully archived records
- Handle changes to table structure
- Easily add more tables
- Extensive investigation revealed that PowerShell would be suitable for moving data, while a config database held the relevant information regarding archived tables.
- PowerShell used a table of archived tables to locate source data, and as new tables were added, the following execution picked them up.
Log tables provided a way to identify the amount of archived records and measure success.
Meanwhile, a list of successful rows was also generated and stored in SQLite, so the manufacturing solution could check the status of data prior to selection for deletion.
Upon completion, a report was generated and emailed to a distribution list as confirmation of a successful execution.
Download the Full Case Study
Data Archiving Solutions at WellData
Data Archiving Solutions are one of WellData’s many database services.
Our database developers support the IT sector with end of data lifecycle management.
Find out more about our data archiving solutions.
