New - FileMaker Repeating Fields Migration Feature

The FmPro Migration Service provides a fixed-price migration of FileMaker Pro databases to a wide variety of destination databases. Database migration target databases include MySQL, Oracle, Access, Microsoft SQL Server, Sybase, DB2, PostgreSQL, FrontBase, SQLite, Valentina and FileMaker Pro 18. The FmPro Migration Service utilizes FmPro Migrator Developer Edition to provide an automated, high-quality migration process for JPEG images, large text fields and numeric data.

For more info please send email or call.

Need to upgrade FileMaker Pro 2,3,4,5,6 to FileMaker Pro 18? Please see the info about the FmPro Upgrade Service.

The features and benefits of using the FmPro Migration Service include:

Fixed Price Service - You know up front what the cost will be to migrate your FileMaker Pro database. Pricing for the migration of each FileMaker Pro database starts at $250 (for up to 25 files and 50Mb of data). Each database to be processed can include up to 25 FileMaker Pro files. This price includes schema design for the destination database, data extraction/import, export and delivery to the customer. Output file formats are based upon the appropriate standardized format commonly used for each destination database (as shown in the table below).

Repeating Fields Extraction - Many FileMaker databases include non-relational data elements called repeating fields. These fields store multiple values within each field and are associated with the main database record by the FileMaker database software. Manually extracting these repeating fields into a relational database structure can be a time consuming and error-prone process. Manually re-keying these records is not practical for many databases due to the number of records which need to be transferred. The FmPro Migration Service can be enhanced with this repeating fields extraction feature in order to extract FileMaker repeating fields into a separate database table in which the records are related to the main table by the primary key. Each iteration of a FileMaker repeating field is inserted as a new record within the repeating fields table. This add-on to the standard FmPro Migration Service costs $150 per FileMaker database file/table.

Experience - .com Solutions Inc. is a FileMaker Business Alliance member with over 20 years of FileMaker Pro development experience. This experience spans FileMaker revisions 1.0 thru 10, Oracle 8.0.5 thru 11g, SQL Server 6.5 thru 2016, MySQL 4.0.12, 5.0 and DB2 8.1, PostgreSQL 8, FrontBase 4.1, SQLite 3 and Valentina 4.

Automated Procedures Improve Accuracy - Manual database migration procedures can take days or even weeks and introduce errors in database structure and records. FmPro Migrator Developer Edition is used to automate time consuming and complex database migration tasks. Furthermore, there is no manual re-keying of data required during any phase of the migration process.

Improved Scalability - FileMaker Pro is optimized for workgroup applications with generally fewer than 999 simultaneous users. Migrating FileMaker Pro data to MySQL, Oracle, Microsoft SQL Server, Sybase or DB2 leverages existing investments in these highly scalable databases capable of handling thousands of simultaneous users.

FileMaker ESS - FileMaker Pro 9+versions include the External SQL Sources feature which enables the use of external SQL data sources within FileMaker solutions. Even though the data is stored within an external SQL data source, can be made available for queries, reporting and data entry within FileMaker layouts. E xisting FileMaker ScriptMaker scripts, layouts and calculations can operate on migrated data residing within SQL data sources.

Multi-Platform Experience - .com Solutions Inc. has extensive experience with database servers hosted on MacOS X, Windows, Solaris and Linux. The FmPro Migration Service provides a very economical alternative to purchasing and supporting additional computer hardware.

Multi-Database Experience - .com Solutions Inc. has years of experience working with different database servers hosted on multiple platforms. Customers benefit from extensive training and real-world experience which may not be available from their in-house IT department. Not having to hire additional employees or high-priced consultants on an hourly basis can also quickly add up to big savings for IT budgets.

Customers with special data confidentiality needs may request alternate migration procedures in order to avoid sending their proprietary data off-site. These options include a scripts-only service, or customer use of the specialized version of FmPro Migrator software which is utilized by this service. Please send email or call for details.

The following table summarizes the databases and output formats which are supported by the FmPro Migration Service: