.com Solutions Inc. - logo  
Products - Header Buttons
.
FmPro Script Diff bullet item 7b FmPro Layout Diff bullet item 7b FmPro Migrator bullet item 7b SQLite Diff
.
.
.
. .

Bookmark This Page

FmPro Migrator Demo Image

order now button

email a friend

FmPro Migration Service - Migrates FileMaker to MySQL, Oracle, Access, Microsoft SQL Server, Sybase, DB2, PostgreSQL and FrontBase

. .

 

Support Matrix
Graphical Interface
Press Clippings and Articles
Resources

FmPro Migrator Developer Edition Table Consolidation Videos
MacOS X Videos
Windows Videos

 

"Just got done with my 20 file consolidation project. It went really
well and thank you for providing this great tool. A real time saver -
took me about 10 hours - I think mainly because the manual was so
clear.
Thanks again for a great app and manual. Definitely worth way more than you charge for it.
Project Stats:
130 layouts
50+ relationships
50+ TOs
100+ Scripts
100+ Value lists
20 files
0 CF's"

Darren Burgess
2-25-2009

"FmPro Migrator Developer Edition 4.56 features support for performing table consolidation projects with FileMaker Pro Advanced 10. The Table Consolidation feature in FmPro Migrator performs an automated batch copy of tables/fields, TOs, relationships, layouts, and scripts."

Philip Michaels
MacWorld.com

1/6/2009

"Moving data structures into FileMaker 7 from older versions or other database systems can be a real nightmare. But FmPro Migrator takes much of the pain out of it. ..."


p 425
FileMaker Pro 7 Advanced For Windows and Macintosh
April 2005

 

"FmPro Migrator from .com Solutions lets you use FileMaker Pro (FMP) as a rapid application development (RAD) tool to prototype enterprise-scale databases for MySQL, Oracle, Sybase, SQL Server, and IBM DB2. ..."


FileMaker Solutions Advisor Zone
January 2004

 

FmPro Migrator saved me hours and hours of learning how-to and migrating my databases.
Thank you very much!

A very satisfied customer,
K Fischer

 

Additional Customers Include:

UCLA
BLM
Pew Trusts
Boston University
Main Medical Center
BellSouth/ATT
SolutionMakers

 


...
.

FmPro Migrator - The migration tool for FileMaker Pro Graphic

FmPro Migrator Platinum Edition 7.34 - Adds FileMaker 13 Compatibility, Save Records as PDF and Save Records as Excel Features

Top 10 Features

black bulletFileMaker Pro Table Consolidation/Rebuild Projects.
black bulletMigrates Microsoft Access databases (including Forms/Reports) to FileMaker.
black bulletConversion of Visual FoxPro, Access, Firebird and SQL Server to FileMaker Pro.
black bulletFileMaker Pro 2-13 to SQL Databases Migration (MySQL, Oracle, Access, Microsoft SQL Server, Sybase, DB2, OpenBase, PostgreSQL, FrontBase, SQLite and Valentina).
black bulletRepeating Fields to SQL Database Conversion.
black bulletImage Export From FileMaker Pro Container Fields.
black bulletExports FileMaker Pro Layouts to PHP web applications, XML Files, Access Forms/Reports, Visual Studio 2010 .Net 4 Projects & Servoy.
black bulletFacilitates FileMaker Pro/FileMaker Server 32 ESS Configurations to MySQL, Oracle and SQL Server.
black bulletConverts FileMaker Pro, Microsoft Access Databases and Visual FoxPro Projects into Full Featured LiveCode Applications.
black bulletAutomates Creation of Relationships, TOs, and Layouts in FileMaker Pro [for Table Consolidation projects].

Description

FmPro Migrator - Migration Process Window

FmPro Migrator is a stand-alone application which quickly and accurately migrates FileMaker Pro databases to MySQL, Oracle, Access, SQL Server, Sybase, DB2, OpenBase, PostgreSQL, FrontBase, SQLite and Valentina. FileMaker Pro database structure and data are migrated to a database table in the destination database. Large text, repeating fields data and container field JPEG preview images are also migrated without manual data entry.

The Table Consolidation feature performs the automated copying of Tables/Fields, Table Occurrences, Relationships, ScriptMaker scripts and Layouts between FileMaker 11 - 13 database files on MacOS X and FileMaker 8 - 11 on Windows.

FmPro Migrator Platinum Edition includes all of the features of FmPro Migrator Developer Edition, but also includes license keys for PHP Conversion, Access to FileMaker, FileMaker to Access database conversions, conversion of Access and FileMaker database into full featured, stand-alone, networkable LiveCode application/RevLets, as well as PHP and BASIC to LiveCode conversions.

Additional features included with FmPro Migrator Platinum Edition includes the conversion of Visual FoxPro projects into LiveCode stacks, Microsoft Access database files, FileMaker Pro database files, Servoy projects, Visual Studio 2010 .Net 4 projects. Most Visual FoxPro Form objects are supported, relationships are imported, and Visual FoxPro code is converted into commented code in the converted database project. Direct data transfers from .DBF files are supported for Access, DB2, FileMaker Pro, FrontBase, MySQL, OpenBase, Oracle, PostgreSQL, SQLite, SQL Server and SyBase database servers.

Feature Comparison Summary

Feature Comparison

To summarize the feature comparison table, FmPro Migrator Platinum Edition is required for performing Access and FileMaker migrations, as well as PHP to LiveCode and BASIC to LiveCode conversions. The remaining feautures can utilize FmPro Migrator Develper Edition or FmPro Migrator Platinum Edition. But in all cases, FileMaker Pro Advanced is always recommended in order to enable the pasting of Table XML code via the ClipBoard.

Table Consolidation Projects

Support Note: The FileMaker 12/13 Table Consolidation feature is fully supported on MacOS X and Windows.

Consolidating a multi-file solution into a single file enables developers to take advantage of improved performance and the new robust security model implemented within FileMaker Pro 7+. Single-file solutions can also be easier to backup/move between computers and even send to users via an email attachment. FmPro Migrator Developer Edition implements automated batch capture and creation features using AppleScript(Mac OS X)/WinAutomation(Windows) for Tables/Fields, Table Occurrences, Relationships, Value Lists, Custom Functions, Layouts and ScriptMaker™ Scripts using FileMaker Pro Advanced 11 - 13.

During the migration process, Table Occurrences and file references are automatically remapped into the new database structure without manual intervention on the part of the developer. TOs are remapped throughout every object of every Layout, Script and Relationship within the new migrated database file.

The 2-pass dependency resolution feature makes 2 automated passes through the Layout creation process in order to resolve dependencies between scripts and layouts. During pass #1 of the layout creation process the layouts are created in the normal manner. ScriptMaker scripts are then pasted into the new database, thus resolving dependencies between scripts and layouts. Then during the 2nd pass through the layout creation process, the contents of each layout are deleted and pasted again, resolving dependencies between layout objects and ScriptMaker scripts.

The Layout text search and replace feature enables developers to quickly repurpose Layouts between database solutions, by changing specified text strings within dozens of Layouts at once. This intelligent search mechanism is implemented to insure that text is changed only within Layout text objects, thus preventing the accidental replacement of text within TOs or field names.

FmPro Migrator Developer Edition creates both static and dynamic Value Lists, with the custom values filled in for static Value Lists. Dynamic Value Lists are created as placeholders for further manual customization by the developer. Static Value List items and Custom Function code can also be edited within FmPro Migrator Developer Edition after being imported from the FileMaker DDR XML file.

Access, Firebird & SQL Server to FileMaker Pro

The Access To FmPro Migration Service built into FmPro Migrator Developer Editon provides a fixed-price conversion feature for Microsoft Access database files to FileMaker Pro database files. This feature includes the conversion of Forms/Reports, Queries, Relationships, Value Lists, Layouts and Visual Basic code.

Using FmPro Migrator, Access databases can be migrated to FileMaker 7+ in order to take advantage of FileMaker Pro's legendary ease of use and increased data management capacity. Migrated Access databases can now grow to the maximum 8TB file size offered by FileMaker 7+ and can be run on MacOS X and Windows.

FmPro Migrator makes a direct ODBC connection to SQL Server databases to automate the mapping of SQL Server columns to FileMaker Pro fields, perform column name to field name conversions and create the tables in the FileMaker database. When using FileMaker Advanced, FmPro Migrator can put the table definition XML code onto the clipboard for easy pasting directly into FileMaker Advanced. On MacOS X, FmPro Migrator utilizes the Actual ODBC Driver for SQL Server from Actual Technologies to make a direct connection to SQL Server and Access databases (purchased separately).

FmPro Migrator makes a direct ODBC connection to Firebird databases to automate the gathering of table structure, relationships and transferring data to FileMaker Pro. Firebird relationships are converted into FileMaker Pro relationships and rebuilt in an automated manner using AppleScript/WinAutomation scripts.

FileMaker Pro to SQL Databases

FmPro Migrator - Step 1 - Get Info Icon FmPro Migrator - Step 2 - Get FieldSize Icon FmPro Migrator - Step 3 - Create Table Icon FmPro Migrator - Step 4 - Transfer Data Icon
FmPro Migrator 4 Step Migration Process

FmPro Migrator documents and migrates FileMaker Pro database structure and data to MySQL, Oracle, Access, SQL Server, Sybase, DB2, OpenBase, PostgreSQL, FrontBase and SQLite. FmPro Migrator interactively reads metadata from FileMaker Pro databases, gets Fieldsize info for each field, creates the table in the SQL database and transfers data (including images and repeating fields) between the databases.

Using the FileMaker Pro/FileMaker Server 9-13 External SQL Sources feature, data can be stored within a MySQL, Oracle or SQL Server database but still be used within FileMaker Pro as if the data was stored locally. Thus achieving the reuse of existing FileMaker Pro layouts and business logic. FmPro Migrator facilitates ESS configurations by performing the initial SQL table creation and data transfer to the SQL database server. Critical tasks performed by FmPro Migrator include the automated sizing of SQL table columns based upon FileMaker Pro field contents and the transfer of repeating fields data into a new relational table structure.

Repeating Fields Migration
Many FileMaker Pro 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 FileMaker Pro. Manually extracting these repeating fields into a relational database structure can be a time consuming and error-prone process. FmPro Migrator easily extracts FileMaker Pro repeating fields into a child database table in which the records are related to the parent table by the primary key. Each iteration of a FileMaker Pro repeating field is inserted as a new record within the repeating fields table as shown in the diagram below. Migrating repeating fields to a SQL database can be an essential step to setting up a FileMaker ESS (External SQL Sources) configuration using MySQL, SQL Server or Oracle.

FmPro Migrator also migrates repeating fields within FileMaker 7+ databases using auto-generated ScriptMaker data transformation scripts. This feature overcomes the lack of repeating fields support within new versions of the FileMaker Pro ODBC driver.

 

Image Export

FmPro Migrator directly transfers data via ODBC to facilitate the migration of large text fields and FileMaker Pro container field data. FmPro Migrator includes a container field export feature for exporting container field data into individual files on disk. Container field data is exported as JPEG data from FileMaker 5/6, and is exported in any one of the 22 supported container field data types for FileMaker 7+ versions, including: EMBO, EMF+, EPS, FILE, FPix, FORK, GIFf, JPEG, JP2, META, METO, moov, PDF, PICT, PNGf, PNTG, qtif.SGI, snd, TIFF, TPIC, XMLO, and 8BPS.

 

Convert Layouts to Functional PHP Web Applications

The PHP Conversion feature built into FmPro Migrator Platinum Edition provides an automated FileMaker Pro to PHP web applications conversion feature. This feature includes the conversion of layouts/forms/reports, scripts, relationships, tab controls and value lists. This feature leverages the automated layout and relationship importing features of FmPro Migrator Platinum Edition.

FileMaker Pro developers can convert existing or new FileMaker Pro database files directly into functional PHP web applications within a few minutes. The converted PHP web application uses the contents of existing layouts to build dynamic web forms having insert, query, update and delete features. Almost all layout objects are converted, including: charts, image fields, tab controls, custom value list menus, field-based value list menus (single and dual field), checkboxes, radio buttons and vector graphic objects (rectangle, rounded rectangle, oval/circle).

 

order now button

 

 

.

hline

. .

.

 

. .

 

 

 

Home | Products | Services | Downloads | Order | Support | Contact

Legal Notices

.
.   .
.
Home Products Services Downloads Order Support Contact