Seeking Professional Advice on Database Migration Decision

#filemaker #database #fullstack #mysql

Hello,

I am a developer working in a rapidly growing business that has relied on FileMaker for several years. As we expand into new markets and handle increasingly sensitive data, we are encountering limitations with FileMaker in terms of performance, security controls, and scalability.

Our current database in FileMaker is approximately 20GB in size, consisting of 387 tables and 925 different scripts. We utilize various API calls and run around 50 scripts on the server at different times throughout the day. Additionally, we heavily rely on mobile devices for tasks such as order processing through barcode scanning.

We are considering the possibility of migrating to a full stack application using technologies such as Java, React, and MySQL. However, we understand that such a migration is a significant undertaking and involves various considerations, including optimizing scripts, restructuring the database, and minimizing the use of SQL within scripts.

Given our specific requirements and the challenges we face with FileMaker, we are seeking professional advice from individuals experienced in both FileMaker and full stack development. We would appreciate insights into the following:

At what point, considering our current setup and future growth projections, would it be advisable to transition from FileMaker to a full stack application?
What are the key factors we should consider when making this decision?
Are there alternative solutions or strategies we should explore before committing to a migration?
What are the potential benefits and drawbacks of migrating to a full stack application, particularly in terms of performance, security, and scalability?
What best practices should we follow during the migration process to ensure a smooth transition and minimize disruptions to our business operations?
We are open to considering all perspectives and appreciate any insights or recommendations you can provide based on your expertise and experience in the industry.

Thank you for your time and assistance.

Best regards,
Collin Short.