FileMaker developers can use the Merge Database/Table Consolidation Feature to upgrade older multi-file solutions into FileMaker Pro 14.

FREMONT, CA, UNITED STATES, July 30, 2015 /EINPresswire.com/ -- 7-30-2014 - Fremont, California - California based .com Solutions Inc. has released FmPro Migrator Developer Edition 7.58 with support for FileMaker Pro Advanced 14 combine database projects. This release supports FileMaker Pro Advanced 11,12,13,14 on MacOSX and Windows.

FileMaker developers can use the Combine Database/Merge Database/Table Consolidation feature to upgrade older multi-file solutions into easier to maintain FileMaker Pro 14 single file solutions. Upgrading to FileMaker Pro 14 also offers developers the opportunity to take advantage of the latest design, development and security features included with FileMaker Pro Advanced 14 and FileMaker Server 14.

Performance testing of FmPro Migrator with FileMaker Pro Advanced 14 includes the following results on MacOS X:
5100 per hour - TOs Creation
616 per hour - Relationship Creation
1200 per hour - Custom Function Creation
2880 per hour - Value List Creation
401 per hour - Layout Importing
401 per hour - Layout Creation - Pass #1
2940 per hour - Script Creation
870 per hour - Layout Creation - Pass #2 (Replacing contents of existing layouts, to resolve dependencies between layouts and scripts)

As a service to the FileMaker community, .com Solutions Inc. has released the FileMaker automation AppleScript code as open source software. In addition to the AppleScript source file, a LiveCode test harness stack is also provided. The test harness stack includes AppleScript handler source code embedded within LiveCode handlers. The code is executed using the LiveCode "do as AppleScript" command. The dynamic compilation of AppleScript code prevents dependencies associated with a specific version of FileMaker software, which would occur if an AppleScript app or applet had been used.
The AppleScript code and LiveCode testing stack are available for download from the File menu in FmPro Migrator, and are available in the commercial and demo versions of FmPro Migrator at no cost.

On Windows, FmPro Migrator utilizes a compiled WinAutomation job, which installs and runs automatically to perform GUI automation tasks (except for relationship creation on FileMaker Pro Advanced 14).

FileMaker to SQL Server conversions now include usability improvements and Unicode compatibility thru the use of NVARCHAR/NVARCHAR(MAX) columns. SQL Server developers who use the SA account during the data transfer process will find that FmPro Migrator writes the converted tables into the SQL Server dbo schema, instead of requiring the manual creation of a new schema.

Additional enhancements with this release include:
-- PHP Conversion Changes
• Fixed an issue with the Inactive Checkbox value not being written when the Admin user updates a user's login account info.
• Added a "Forgot Password?" button to the login.ctp file.
-- .NET Conversion Changes
• Improved the generation of VB and C# code for situations in which the controls in the original database are not data bound. These controls will now reference a Placeholder_Table/Placeholder_Field to prevent errors in Visual Studio.
• Improved the FileMaker GUI automation processing on Windows by using PowerShell instead of VBScript to find the version number of the currently running copy of FileMaker Pro Advanced.
• Fixed issues with the automated creation of scripts and Relationships on MacOS X and Windows with prior versions of FileMaker Pro Advanced.
• Added support for parsing of FileMaker 14 Script Steps when reading scripts from clipboard.
• Updated SQL Server table creation SQL to use NVARCHAR and NVARCHAR(MAX) in place of VARCHAR and TEXT column types for Unicode compatibility. To insure full UTF8 support, hold down the shift key when transferring data and make sure that the FileMaker ODBC driver Advanced Language feature is configured for UTF8. The NVARCHAR(MAX) column type is compatible going back to SQL Server 2008.
• When using the SQL Server sa account, no schema needs to be created because FmPro Migrator will write the tables into the dbo schema.
• Added a feature to automatically create the SQL Server schema when creating the database table, if the table cannot be created due to the lack of a schema name matching the login name.
• FmPro Migrator application and its components are now digitally signed with a Comodo digital code signing certificate on Windows and an Apple Developer Certificate on MacOSX.

For more info about the FmPro Migrator FileMaker Table Consolidation/Merge Database feature, please see:
http://www.fmpromigrator.com/products/fmpro_migrator/index.html#table_consolidation

David Simpson
.com Solutions Inc.
510-555-1212
email us here