FmPro Migrator 5.01

Migrates CSV files to Oracle and MySQLMigrates TAB delimited files to Oracle and MySQLHost FileMaker Pro databases at any ISP supporting MySQLDocuments FileMaker Pro database structureMigration of large text fields and image data to OracleProcessing of up to 50 open FileMaker Pro databases. FmPro Migrator also supports FileMaker Pro stand-alone solution files.

Major Features:

1. 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 Mac OS X and Windows.
2. Utilize the New FileMaker 7 Security Model - Consolidating multiple database files into a single FileMaker 7 database file enables developers to utilize the new FileMaker 7 security model. FileMaker solutions can be developed in less time and with better security by utilizing the new FileMaker 7 security model.
3. Migrate SQL Server databases to FileMaker 7, 8, 9 - FmPro Migrator makes a direct ODBC connection to SQL Server databases to automate the mapping of SQL Server columns to FileMaker fields, perform column name to field name conversions and creates the tables in the FileMaker database. When using FileMaker Advanced, FmPro Migrator can put the table definition XML code onto the clipboard for easy pasting directly into FileMaker Advanced. On MacOS X, FmPro Migrator utilizes the Actual ODBC Driver for SQL Server from Actual Technologies to make a direct connection to SQL Server databases (purchased separately). On Windows, FmPro Migrator utilizes the SQL Server ODBC driver supplied by Microsoft in order to make a direct connection to the SQL Server database.
4. Automated Reporting from SQL Server Data - FileMaker 9 enables the creation of economical SQL reporting solutions compared to alternative products, using the new External SQL Sources feature. FileMaker also provides enhanced exporting capabilities including the direct creation of Excel spreadsheets and Adobe PDF files. FileMaker 9 Advanced can be used to create royalty-free FileMaker stand-alone solution packages for distribution to multiple desktops.
5. Migrate Access databases to FileMaker 7, 8, 9 - [FmPro Migrator for Windows and MacOS X Feature] - Using FmPro Migrator, Access databases can be migrated to FileMaker 7 in order to take advantage of FileMakers legendary ease of use and increased data management capacity. Migrated Access databases can now grow to the maximum 8TB file size offered by FileMaker 7 and can be run on MacOS X and Windows.
6. Migrate FileMaker Repeating Fields - FmPro Migrator migrates data within FileMaker repeating fields as related records within a new table for all databases. This feature converts previously non-relational data into relational database structured format for compatibility with destination database. Previously, this type of work had to be performed via time consuming manual procedures, but this task is now automated by FmPro Migrator. [When migrating FileMaker 7 databases, FmPro Migrator generates ScriptMaker data transformation scripts, which can be pasted into FileMaker via the clipboard. This feature overcomes the lack of repeating fields support within new versions of the FileMaker ODBC driver. Repeating fields data can now be transferred to SQL databases and used with the new External SQL Sources feature incorporated within FileMaker 9].
7. Container Field Export Feature - The container field export feature supports the 22 container field data types available within FileMaker 7, 8, 9 database files including: EMBO, EMF , EPS, FILE, FPix, FORK, GIFf, JPEG, JP2, META, METO, moov, PDF, PICT, PNGf, PNTG, qtif.SGI, snd, TIFF, TPIC, XMLO, 8BPS.
8. Scale Up FileMaker Pro to Enterprise Class Capacity - Running out of performance with your FileMaker solution? FmPro Migrator enables quick and accurate migration of your database structure and data to highly scalable enterprise class servers. Oracle and MySQL databases also provide enhanced transaction control and recoverability beyond the capabilities of FileMaker Pro.
9. Prototype and Test Database Web Implementations - Use FileMaker Pro to prototype and test web-based database solutions prior to implementation on enterprise class databases. FmPro Migrator permits quick prototyping of database applications once the structure has been developed in FileMaker Pro.
10. Save Thousands of Dollars with Generated Perl CGI Scripts - FmPro Migrator instantly generates robust Perl CGI scripts allowing insert, query, update and delete of migrated data for each migrated database. IT departments can save thousands of dollars and weeks of development/debugging effort over manually created scripts.
11. Save money on ODBC drivers for UNIX web servers - Perl CGI scripts generated for Access and SQL Server databases for Linux/UNIX/MacOS X web servers utilize the open source Perl DBI:Proxy software eliminating the need for ODBC drivers to be installed on the web server. This means that IT departments can typically save $3500 to $10,000 per web server which would normally be required in order to license ODBC drivers for UNIX servers.
12. Host FileMaker Pro Data at Virtually Any ISP - The MySQL database is the most popular open-source database available today. Virtually every ISP offers inexpensive MySQL database hosting with their hosting plans. Some ISPs even offer free MySQL database hosting after payment of a minimal setup fee. By migrating data to a MySQL database you have a wider choice of database hosting providers compared to looking for FileMaker Pro hosting providers.
13. Transfer Structure and Data - FmPro Migrator directly creates each table in the destination database at the click of a button. Even if you have never previously worked with one of these database servers, you can let FmPro Migrator effortlessly create the basic SQL code required to create the destination database table to hold your data. FmPro Migrator will also automatically attempt to identify and implement a unique primary key for your new database table and will create the appropriate trigger and incrementing sequence too (Oracle databases).
14. Process Images via the Web With Ease - The Perl CGI scripts generated by FmPro Migrator automatically provide support for insert/update/view/delete of GIF/JPEG images via a web-based interface. The generated Perl CGI scripts automatically perform special processing for all FileMaker Pro container fields in order to enable web users to work with image data within the migrated database. Non-image data (such as pdf, wav, MS Word and binary data) can also be processed with no programming changes to the generated files. These specialized data types are stored within the appropriate BLOB/LongBLOB column type within the destination database.
15. Improve Accuracy, Avoid Manual Data Entry - Database data is accurately migrated into the exact format required by the destination database. No manual processing or re-keying of data is required! These files are produced by FmPro Migrator within a few seconds at the press of a button, instead of the hours or days of work typically required for a DBA to write, test and debug these scripts manually.
16. No syntax errors - FmPro Migrator for MacOS X uses Apple Events via AppleScript (on MacOS X), FileMaker table definition XML code from the clipboard, ODBC connections to databases or the direct reading of FileMaker binary files to to query and document the structure of each FileMaker Pro database.
17. Stand-Alone FileMaker Solutions Supported - FmPro Migrator includes the ability to document and generate migration scripts for stand-alone FileMaker Pro solutions. Documenting or migrating a stand-alone solution file could be critical to business continuity needs. You could spend $300 - $500 just for competing documentation tools for FileMaker Pro.
18. Economical Infrastructure - The Perl CGI scripts generated by FmPro Migrator leverage popular industry-standard open source software including Apache (Linux/UNIX/MacOS X/Windows), Perl 5.6, MySQL, PostgreSQL, DBI/DBD and CGI.pm. IT departments can save thousands or even tens of thousands of dollars utilizing these scripts with an open source infrastructure instead of purchasing high-cost application server software.
19. Transfer Large Text Fields and Images - FmPro Migrator automatically facilitate the migration of large text fields and image data within FileMaker Pro container fields. FileMaker text fields containing more than 255 characters will be migrated to large text type columns in the destination database table. This determination is made automatically and is based upon reading the data gathered during the Step #2 Get Fieldsize step. FileMaker container fields are migrated and transferred into the appropriate BLOB/IMAGE type column in the destination database.
20. Support for a Wide Range of Databases - FmPro Migrator incorporates unmatched versatility compared to other FileMaker migration tools. FmPro Migrator includes support for migrating FileMaker to MySQL, Oracle, Access, SQL Server, Sybase, DB2, OpenBase, PostgreSQL and FrontBase.
21. Save Your Configuration - FmPro Migrator automatically saves your configuration information into its own MigrationProcess.db3 SQLite file within the output directory. You can re-open and reuse this information at any time in the future to continue or update an existing migration project..
22. DBA Can Review/Modify Generated Scripts - FmPro Migrator permits the DBA to review and customize table creation SQL scripts which will be sent to the database server.
23. Iterative Process - Because FmPro Migrator makes the process so efficient, you can quickly update and re-run a migration process based upon changes made to your FileMaker databases.
24. Context Sensitive Help - Clicking a table name in the Migration Process window displays instructions and troubleshooting info which is specific to the type of migration currently being performed.
25. Use FmPro Migrator To Document Existing Databases - FmPro Migrator can be used to produce documentation files for existing FileMaker Pro databases and stand-alone solutions files. This documentation can be used to make up for information which was omitted by the original developer or consultant. This documentation is written in a few seconds for every FileMaker database/table for which information has been gathered. The ability to produce high quality documentation on demand can be vital to passing an IT audit by a potential investor or new business partner.
26. Follow Security Best Practices for Perl CGI Programming - The Perl CGI scripts generated by FmPro Migrator are designed to follow industry standard best practices regarding web form processing. Denial of service attacks are prevented by preventing file uploads unless images/BLOB data is being submitted by the form. Critical web form processing parameters are hard-coded within each script instead of being accepted via POST or GET operations - thus preventing web form hijacking. Web attackers cannot view sensitive data by guessing at and passing in their own database column names for processing. The record deletion script carefully checks the referrer of submission requests in order to insure that the request was submitted via a trusted web server URL. Attempts by an attacker to submit to this form from other web servers will fail. Security is further enhanced by insuring that the functionality of record deletion is incorporated within a separate series of scripts which can be omitted from installation on publicly accessible web servers.
27. Perl CGI Scripts Follow FileMaker Layout Structure for Improved Security - It is a common FileMaker database development technique to use layouts to limit the information which is accessible by different groups of users. FmPro Migrator generates different sets of Perl CGI scripts for each layout within the FileMaker database in order to enhance the security of migrated web-based applications. Each Perl CGI script generated by FmPro Migrator makes use of hard-coded database column names and input parameters in order to insure that a web attacker cannot compromise security.

Enhancements:

• Added support for migrating Firebird database Tables/Fields, Relationships and data into FileMaker Pro database files.
• Fixed issue with external file references not being removed from scripts in some situations, during Step #5 of the Table Consolidation process
• Fixed an issue with displaying Destination DB Username upon first launch.
• Converted FileMaker comment characters to Visual Basic comment characters during FmPro to Access script conversions.
• Fixed cosmetic issue with TOs list field title.
• Fixed issue with processing of scripts to demo limit during FmPro to Access script conversions.
• Fixed issue when clicking Step #2 button during Table Consolidation projects, the Layouts screen now opens instead of Value Lists screen. Updated dialog text to refer to batch importing of Layouts from DDR XML files.
• Fixed issue when clicking Step #3 button during Table Consolidation projects, the Scripts screen now opens instead of the CFs screen.
• Updated Instructions text Layouts screen to to refer to batch importing of Layouts from DDR XML files.
• Corrected TO remapping during Table Consolidation projects to use same case characters in XML replacement text within scripts and layout XML. This doesn't affect FileMaker, but external XML processing tools/programming languages will be happier with this change.
• Fixed issue updating TO File Reference fields on TOs tab.
• Updated WinAutomation Jobs and QuicKeys shortcuts to click OK button when deleting/pasting layouts containing TAB panel objects during layout processing Pass#2.
• Updated layout DDR XML importing code with special processing for XML attributes/tags: ,,tableViewVisibility in order to reconcile differences between layout XML code in DDR file with Clipboard.
• Known Issue:Some TAB Panels may not paste correctly if they were imported from a DDR XML file. These layouts should be copied and pasted manually if there are only a small number of layouts having TAB panels, otherwise the layouts should be copied into FmPro Migrter Developer Edition using the automated clipboard importing method.