Migrate FileMakerPro data to SQL Server

Posted on 2009-04-28
Last Modified: 2012-08-13
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.
Question by:BMCKRob
    LVL 12

    Expert Comment

    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.

    Author Comment

    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.
    LVL 12

    Accepted Solution

    I've not used it myself, but the tool I've seen the most about is FmPro Migrator.  It may be what you are looking for.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    Pop up windows can be a useful feature of any Filemaker database.  Though best used sparingly, they can be employed in a multitude of different ways, for example;  as a splash screen at login, during scripted processes to control user input, as pick…
    Having just upgraded from Filemaker 11 to Filemaker 12 over the weekend, we thought we would add some tips for others making the same move.  In general, our installation went without incident. Please note that this is not a replacement for Chapter 5…
    To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    732 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    24 Experts available now in Live!

    Get 1:1 Help Now