FmPro Migrator 9.37 Adds New MySQL to FileMaker Pro Conversion Feature

September 16, 2021 in FileMaker (E)

[] Fremont, California - .com Solutions Inc. announces the addition of a new MySQL to FileMaker Pro conversion feature within FmPro Migrator 9.37. FmPro Migrator is a stand-alone application which quickly and accurately migrates FileMaker Pro databases to MySQL, Oracle, Access, SQL Server, Sybase, DB2, PostgreSQL, and SQLite. 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.

MySQL is one of the most popular database platforms in use today. FileMaker Pro is widely recognized for being the leading low-code database development platform. FmPro Migrator brings these two database platforms together by offering bi-directional schema and data transfers between them. FileMaker Pro developers can help companies skip IT scheduling bottlenecks by moving SQL database apps into FileMaker Pro solutions.

FmPro Migrator uses an automated 3-step process to migrate MySQL tables and data into a local copy of FileMaker Pro running on your desktop. Once completed, the FileMaker Pro database is ready to serve as the starting point for building or enhancing FileMaker Pro solutions.

Using the FileMaker Pro development platform, previously online only MySQL databases can now be used in offline desktop and mobile apps. FileMaker Pro solutions running on desktop and mobile platforms enable users to edit data locally and sync to the server once the internet connection has been restored.

FileMaker Pro solutions deployed to macOS, Windows, IOS or Android devices using LiveCode for FM include built-in support for offline sync to FileMaker Server using the data API.

FmPro Migrator connects to MySQL and FileMaker databases using UTF-8 encoding in order to insure that all characters are transferred accurately between databases. Alternate data transfer methods might not retain all character encoding. FmPro Migrator saves money and reduces errors by avoiding manual data entry of large data sets.

FmPro Migrator 9.37 also includes the following improvements:

* Visual FoxPro & Other Data Conversions - The compiled Perl xferData.EXE 32bit and 64bit apps have been updated to include additional dll libraries to insure errors don't occur if Perl isn't installed on the computer when xferData.EXE is used. This utility is used with all Visual FoxPro conversions and also other data transfers when holding down the shift key.

* VB6 to LiveCode Conversion - Fixed a couple of issues found when converting fonts and colors from VB6 to LiveCode.

* Access to FileMaker Conversion - Updated the AccessDDRExport utility to version 33 in order to fix Error #53.

* Table Consolidation - Enhanced the Relationship_Error_Report.txt with a SQLite delete command, to make it easier to delete defective relationships to allow the automated relationship creation process to continue. Fixed an issue in which the FmPro Migrator AppleScript file wasn't created properly when selecting the File -> Export AppleScript or WinAutomation Scripts menu.

* SQL Server to FileMaker - Fixed an issue with SQL Server to FileMaker conversions in which the error text Invalid column name Ctable_name... was displayed when gathering metadata from SQL Server. Fixed an issue with SQL Server to FileMaker Transfer data step in which the "Gathering Data" dialog was displayed without data being transferred. Now these data transfers use the xferDataPerl.EXE/App in all situations. Fixed an issue with SQL Server to FileMaker conversions in which the FileMaker login info was incorrect because it was using the SQL Server login info.

* LiveCode Conversion - Fixed an issue with the saveRecordsAsPDF handler in which a couple of local variables weren't declared (added: tFoundSetFlag,tCurrentRecordPosition). This problem will only show an error if the Variable Checking feature is enabled in the LiveCode IDE - this is the recommended setting to help catch typos.

* General GUI - Made a cosmetic improvement to the position of the right edge of fields displayed on the various tabs of the Migration Process window. Fixed an issue with the FileMaker Pro Networking app causing FmPro Migrator to give the error that 2 or more copies of FileMaker are running when performing AppleScript based GUI automation tasks on macOS. These processes may show up as: fmscwpc or node app.js in the process list.

* FmPro Migrator Batch Transfer - Updated the manual with info about 64-bit support now being available.

* FileMaker to Access Conversion - Replaced the Access2013.accdc file with with a zipped copy of the Access2016.accdb to prevent security errors when opening the file. Added a dialog to the Image Export to SQL Database feature and the PDF manual recommending the use of the Microsoft SQL Server Migration Assistant for dealing with transferring of images into Access databases from FileMaker Pro. Updated the PDF manual to specify using the UTF-8 encoding option when configuring the Advanced Language options of the FileMaker ODBC driver. Since Access databases always use the xferDataPerl.EXE data transfer method - the generated Perl scripts always use SQL_WVARCHAR instead of SQL_VARCHAR to insure that Unicode data is transferred properly.

Pricing and Availability:
For a limited time, as part of the MySQL to FmPro feature introduction, FmPro Migrator (including Developer Edition and Platinum Edition features) is available for a 50% discount ($49.50) and is available immediately.

Founded in 1999 by David Simpson in Sunny California, .com Solutions Inc. develops multi-platform graphical applications supporting FileMaker Pro, SQLite, Oracle, MySQL, Access, SQL Server, Sybase, DB2, PostgreSQL, LiveCode and Visual FoxPro developers. FmPro Script Diff, compares and edits FileMaker Pro scripts. SQLite Diff compares SQLite database schema and data. Copyright (C) 1999-2021 .com Solutions Inc. All Rights Reserved. FileMaker is a registered trademark of Claris International, Inc. - an Apple company. Apple, the Apple logo and macOS platforms are trademarks of Apple Inc. in the U.S. and/or other countries.


Facebook Profile: View
LinkedIn Profile: View
Twitter: View

FmPro Migrator 9.37 Adds New MySQL to FileMaker Pro Conversion Feature Image