Solving Client Challenges with Two-Tier Architecture on Azure

Business Problem:

A mid-sized clinic has been running its appointment booking and patient records system on-premises for over a decade. The system is built with a desktop front-end and a local SQL Server database. Recently, they’ve faced issues like:

• Frequent downtime due to outdated hardware

• Limited access for remote staff and doctors

• High maintenance costs for local servers

• No disaster recovery or offsite backups

The clinic's management wants to modernize the system but doesn’t want to fully re-architect it due to budget and time constraints. Their key priorities are:

• Enabling web access to the system for staff working remotely

• Reducing infrastructure maintenance costs

• Improving data reliability and backup