[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 463
  • Last Modified:

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.
0
BMCKRob
Asked:
BMCKRob
  • 2
1 Solution
 
North2AlaskaCommented:
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.
0
 
BMCKRobAuthor Commented:
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.
0
 
North2AlaskaCommented:
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.

http://www.fmpromigrator.com/products/fmpro_migrator/index.html
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now