Database and Report System Upgrade (MS Access to MS SQL)
After my project of replacing HMI/SCADA systems, I had the task of upgrading the main data storage server. The existing software used for collecting the data and reporting was a proprietary Visual Basic application. I removed the function of “pulling” the data from the server and instead used the HMI/SCADA computers to “push” the data to the server. The Visual Basic application was replaced with Excel (with VBA) for reporting.
This allowed the client to request modifications to better fit their needs, making reporting faster and more efficient. MS Access was also changed over to MSSQL to improve reliability and sharing of data.