Modernizing a testing database
North Carolina Department of Agriculture · State government
An essential Feed & Forage testing system was running on a Microsoft Access database with no available source code. I served as the sole contractor on the federally funded project to modernize the system, migrate its data and restore a maintainable technical foundation.
The work included replacing the Access database with Microsoft SQL Server, upgrading reporting capabilities and ensuring the new source code was properly delivered into version control.
The challenge
The existing application depended on Microsoft Access, its original source code was unavailable and the system needed to continue supporting department operations.
What I did
I modernized the database environment by migrating it from Microsoft Access to SQL Server and creating replacement reports using SSRS. The project also established proper source and version control for the resulting code.
The result
Access to SQL Server
The department received a modernized SQL Server solution with new reporting capabilities and properly managed source code.
Rather than leaving an important operational system dependent on an aging database and unavailable source code, the project created a more maintainable foundation for continued use.
Technology and skills
Microsoft Access • SQL Server • SSRS • Database migration • Reporting
Related services
Learn more about legacy software modernization and data consulting.
Facing a similar problem?
Start with a free 30-minute conversation to discuss the problem and see whether I’m a good fit.
Detailed assessments and project planning are available through paid discovery.