Modernising Brisbane Seniors Online’s Core MIS & Database Infrastructure
Brisbane Seniors Online faced critical operational risks and scalability bottlenecks due to an aging Microsoft Access-based Management Information System (MIS). To protect core community services—spanning member management, financial tracking, and regional coordination—C9 delivered a comprehensive custom modernisation program.
The solution replaced the fragile legacy database with a secure, high-performance .NET application backed by Microsoft SQL Server. Through a meticulously engineered migration strategy, we successfully cleansed, validated, and transferred 100% of historical member data with zero data loss, entirely eliminating legacy crash risks and establishing a reliable, future-proof foundation for ongoing operations.
Key Functionality
- Member and User Management: Streamlined administration of member profiles, profiles history, and system users.
- Chapter and Postcode-Based Structures: Organised operational layers aligned with regional chapters and postcodes.
- Role and Access Control: Secure permission levels governing system access and user authorization.
- Fee and Receipt Tracking: Accurate financial recording and transaction tracking.
- Communications & System Status: Management of official letters, messaging, and system status updates.
- Operational Logging & Auditing: Comprehensive data tracking for system activity and administrative accountability.
- Configuration & Lookup Data: Tailored underlying data structures supporting consistent system behaviour.
Core Technologies & Architecture
- Application Layer: Built using a modern .NET-based application layer to ensure high performance, clean code maintainability, and seamless extension capabilities.
- Primary Data Store: Powered by Microsoft SQL Server to replace the legacy Microsoft Access database, ensuring high data integrity and reliability.
- Architectural Separation: Implements a clean separation of application logic from data storage, ensuring the system is modular and easy to manage.
- Migration Framework: Utilises a dedicated, custom migration process developed specifically to safely transfer, cleanse, and validate data from Access to SQL Server.
- Future-Proof Foundation: Architected deliberately to support web-based interfaces and potential mobile extensions in future phases.
- Modern Hosting Infrastructure: Deployed to run on reputable, high-performance modern infrastructure providers to guarantee ongoing uptime and security.
Project Outcomes & Impact
By modernising Brisbane Seniors Online’s core infrastructure, C9 successfully eliminated their long-term reliance on an unsupported Microsoft Access environment. The redeveloped .NET system dramatically improved data entry speed, secured sensitive member records against corruption, and reduced administrative overhead. Most importantly, the engagement provided the non-profit organisation with a stable, scalable platform capable of supporting their community programs and future digital growth for years to come.