.com Solutions Inc. announces the release of FmPro Migrator 9.37 with MySQL to FileMaker Pro and improvements to Microsoft Access and Visual FoxPro Conversions.
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 Code.zip 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, VB6, 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.