Link to home
Start Free TrialLog in
Avatar of BMCKRob
BMCKRob

asked on

Migrate FileMakerPro data to SQL Server

We have a rather complex BI application created in FileMaker Pro that is too slow and we would like to know if there is a way to migrate the data to our SQL Server 2005 and use the FileMaker Pro front-end?  If so, how do we go about it?


Something like the upgrade wizard in MS Access to upgrade the database to SQL Server and use Access as the front-end. We have done this and it is fairly easy to do.
Avatar of North2Alaska
North2Alaska
Flag of United States of America image

FileMaker 8, 9 and 10 has the ability to connect to external databases via ODBC.  To continue to use FileMaker as the front end would replacing the local tables with external ones.

But I don't think this will solve your first concern that it is slow.  You would still be using FileMaker and you would have added potentially additional performance issues by adding in the network and ODBC into the mix.

Is your FileMaker application as optimized as it can be?  Is there "old code" and calculations that could be removed to speed things up?

If you have done all you can to tune FileMaker and are still dissatisfied, it may be time to develop a new solution.
Avatar of BMCKRob
BMCKRob

ASKER

We were aware that you could use SQL Server as the backend database for FileMaker but we want to know if there is some kind of migration utility, either with FileMaker or third party, that would migrate the database from FM to SQL Server and maintain the connection to the FM front-end?

Speed isn't the only concern, we need access to the data in this app, and it needs access to data that is in SQL Server.
ASKER CERTIFIED SOLUTION
Avatar of North2Alaska
North2Alaska
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial