Enterprise Application
Tour Receptive CRM
Replacing a 20+ year legacy system with zero business interruption
The Challenge
A Maine-based tour receptive company that coordinates large group tours faced significant operational challenges with their existing system — a VBA/Access application built over 20 years ago.
Technical Debt
A bloated VBA codebase with poor architecture and no separation of concerns.
Data Integrity Issues
A poorly designed database schema leading to data inconsistencies.
User Experience
Clunky interface with workarounds that created bad habits and inefficiencies.
Business Risk
Heavy reliance on a single legacy technology with limited expertise available.
The business could not stop operating during the transition — tours needed to be booked, proposals sent, and reservations managed without interruption.
The Solution
Designed and implemented a modern three-tier architecture to replace the legacy system while enabling progressive migration.
Modern Web Application
Interactive calendar with tour visualization. Card-based management interfaces. Comprehensive activity tracking. Role-based authentication.
API Layer
Clean interface enabling future mobile apps and third-party integrations.
Redesigned Database
A new schema built from the ground up to address legacy data issues, with proper relationships and change tracking.
Key Innovation
Rather than a risky 'big bang' migration to the new system, a side-by-side deployment model was architected that allows both applications to run simultaneously.
Bidirectional Sync Service
A custom-built Windows service that synchronizes data between the legacy and new databases in real-time, handling structural divergence through entity-level and property-level sync handlers with conflict resolution.
Field Locking System
A VBA module that progressively makes fields read-only in the legacy application, gently guiding users to the new system while maintaining full data visibility.
This approach delivers immediate value — the client can use new features as they're built without waiting for full feature parity.
Document Generation
One of the highest-value features is the automated document generation system that replaces hours of manual work.
All built with open-source tools — zero licensing costs.
Business Impact
Hours → Seconds
Document Generation
Zero Downtime
Progressive Migration
Improved
Data Quality
$0
Licensing Fees
Time Savings
Document generation reduced from hours to seconds per tour.
Zero Downtime
Progressive migration with no business interruption.
Data Quality
Improved validation and schema design eliminates inconsistencies.
User Adoption
Modern UX with guided transition from legacy system.
Scalability
Architecture supports growth without additional admin overhead.
Future-Ready
API-first design enables future mobile or integration capabilities.