When a FileMaker solution has become difficult to use or maintain, a complete rebuild may seem like the most direct answer. In many cases, however, targeted improvements can solve the immediate problems with less cost, risk, and disruption.
Improve or rebuild?
A mature FileMaker solution usually contains years of business rules, historical data, reports, and exceptions that are easy to underestimate. Targeted improvements can address performance, usability, security, and workflow problems while preserving the parts of the system that already work well.
Rebuilding becomes more reasonable when the schema is fundamentally unsuitable, the files are damaged or unstable, security cannot be corrected cleanly, or years of disconnected additions make ordinary changes excessively risky.
A rebuild may also be appropriate when the organization’s business model has changed so substantially that the existing structure no longer represents the work.
Cost and disruption
A new system must reproduce important behavior that users may take for granted, including reports, calculations, data rules, integrations, and uncommon workflows. Rebuilds also require data migration, extensive testing, user training, and a transition plan for work performed during the changeover.
Many organizations benefit from improving the most problematic modules first while leaving stable areas in place. New functionality can be introduced in stages, allowing users to test changes and the organization to spread cost and risk over time.
Making the decision
The decision should follow a review of the current architecture, performance, security, technical debt, user needs, and future plans. Portage Bay Solutions can compare the cost and risk of targeted improvements, phased modernization, and a full rebuild before your organization commits to a direction.