FmPro Migrator

FmPro Migrator quickly and accurately migrates FileMaker Pro database structure and data to MySQL, Oracle, Access, SQL Server, Sybase, DB2, OpenBase, PostgreSQL, FrontBase, SQLite and Valentina.

• Converts FileMaker Pro databases into PHP Web applications [Platinum Edition]
• Converts Access Forms/Reports, Relationships, Value Lists, Queries and Visual Basic to FileMaker 11
• Converts Visual FoxPro projects into any supported database or IDE [[Platinum Edition]
• Converts FileMaker Pro, Access, Visual FoxPro projects into Visual Studio 2010 .Net 4 [Platinum Edition]
• Converts FileMaker Pro Layouts/Scripts/Value Lists to Microsoft Access
• Converts FileMaker Pro Layouts/Scripts/Value Lists, Relationships to Servoy Projects
• Converts Layouts to HTML/JavaScript
• Converts FileMaker Pro and Microsoft Access databases into full featured LiveCode application stack files
• Migrates Access, Firebird and SQL Server to FileMaker 11
• Automated Table Consolidation Feature
• Facilitates FileMaker ESS Configurations
• Host FileMaker Pro data at any ISP supporting MySQL
• Documents FileMaker Pro database structure
• Migration of large text fields and image data for all supported databases
• No ODBC driver licensing required for UNIX servers
• Repeating Fields Extraction
• Economical Single-User License
• FileMaker image export feature
• Export Layout XML to individual files
• PHP to LiveCode Conversion (Platinum Edition Feature)
• BASIC to LiveCode Conversion (Platinum Edition Feature) FileMaker Pro database fields containing more than 255 or 4000 characters of text are migrated to the appropriate large text column type in the destination database. Container field data within FileMaker Pro container fields is migrated directly to the appropriate BLOB type of database columns through a network connection. No manual data entry is required for processing either of these specialized data types.

• Fixed a memory leak during batch importing of layouts, which could cause a crash.
• Fixed an issue reading the correct number of fields with the Demo version when performing Access to FileMaker conversions.
• Updated LiveCode template stack to v48. Added support for SQL Yoga 1.1.1 dbconn_setVendor feature for SQLite connections, adding "binary,extensions" options. This change means that SQLite BLOB column data will be readable with 3rd party SQLite tools.
• Fixed a cosmetic issue with the display of the main window tabbed folder on MacOS X Yosemite.
• Fixed a cosmetic issue with the display of the Field Details button on the Migration Process window in Table Consolidation operating mode.
• Fixed a cosmeetic issue with the display of Unicode characters in the display of Custom Functions, TOs in the Migration Process window.
• Fixed an issue updating Layout TO names containing Unicode on the Layouts tab in the Migration Process window.
• Fixed an issue in which some CREATE TABLE long column names would get terminated with the @ symbol.
• Improved the error message when connecting to MySQL database servers.
• Improved the error message displayed when copying tables into FmPro Migrator via the clipboard, to suggest extracting the app from the ZIP/DMG file prior to running the app.
• -- PHP Conversion Changes
• Fixed an issue with escaped quotes in FileMaker calculations causing a syntax error in the generated PHP code written into CakePHP Model files.
• Fixed the incorrect display of Spry Tabbed Panels, and background color of Spry tabbed panels from FileMaker 13 database layouts.
• Improved compatibility with newer PHP versions by adding app/Model/DataSource/CakeSession.php file, with 'session.auto_start' => 0, line of code commented.
• Enabled the use of the Add and Delete buttons on the navigation toolbar in Find mode for applications created using the "Read Only" data access feature. This change allows users of Read Only applications to Add and Delete their own find requests.
• Added the conversion of FileMaker global variables into PHP SESSION variables for the Set Variable, IF and ELSEIF script steps.
• Added the automated commenting of beforeSave()/afterSave() functions within Model files when creating a PHP web application having Read Only Data Access.
• Improved the code in the ToolbarsController.php file to reduce memory usage for large data sets, largely eliminating out of memory errors with MySQL queries.
• Fixed an issue with the display of Query operators using UTF8 unicode.
• Fixed issues with User login code.
• Removed support for CakePHP 1.x from the PHP Conversino GUI menu.
• Fixed a display issue with Spry Tabbed Panels with only one Panel on the form.
• Fixed an issue with Custom Value List items containing Unicode characters not displaying properly.
• Note: It is recommended that ASCII characters be used for Value List names, since these get used to construct function names.
• Fixed an issue with FM13 Tab Panel names and font color not being retrieved.
• Improved Spry TabbedPanel processing by enabling the background color of the Tab to be different from the background color of the panel containing the objects.
• Improved the PHP Conversion "Missing PK Column" error dialog to suggest copying the tables into FmPro Migrator again, after making changes in the source database.