View Image

FmPro Migrator is a stand-alone application which migrates FileMaker databases to MySQL, Oracle, Access, SQL Server, Sybase, DB2, OpenBase, PostgreSQL and FrontBase. SQL Server and Access databases can also be converted to FileMaker 7, 8, 9.
FmPro Migrator Developer Edition includes all of the features of FmPro Migrator, but also includes a Table Consolidation feature which performs the automated copying of Tables/Fields, Table Occurrences, Relationships, ScriptMaker scripts and Layouts between FileMaker 8, 8.5 and 9 database files on MacOS X and Windows.

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.

Database data is accurately migrated into the exact format required by the destination database. No manual processing or re-keying of data is required! The FmPro Migrator graphical interface is used to directly get FieldSize info concerning FileMaker fields, create tables in the SQL database and transfer data between database files. All of these tasks are quickly and accurately performed via the FmPro Migrator Migration Process window at the click of a button, instead of the hours or days of work typically required for a DBA to write, test and debug scripts manually.

Additionally, FmPro Migrator includes the ability to document stand-alone FileMaker Pro solutions files running on MacOS X or Windows. Documenting or migrating a stand-alone solution file could be critical to business continuity needs. You could spend $300 - $500 just for a documentation-only tool for FileMaker Pro - but not anymore.

How it Works
FmPro Migrator on MacOS X either directly reads the structure of an empty FileMaker binary file (FileMaker 2,3,4,5,6) or uses Apple Events via AppleScript to query the FileMaker Pro application for information about each of the database files which are currently open. Alternately, with FileMaker Advanced 8+ databases, FmPro Migrator reads the table creation XML code directly from the FileMaker clipboard.
On Windows, FmPro Migrator reads metadata directly from an empty FileMaker binary file (using FileMaker 2,3,4,5,6), directly from the clipboard (using FileMaker Pro 7+), or from an ODBC connection to the FileMaker database.