FmPro Migrator 2.35 EE for FileMaker to MySQL

[MacDev-1 Moderator]

Title: FmPro Migrator 2.35 EE for FileMaker to MySQL

This message comes to you from MacDev-1(tm) -- the Mac(tm) OS Developer
News and Info server.  See below for more info on this list (including
sub/unsub details).

__________________________

10-26-2004 - Fremont, CA - .com Solutions Inc. Releases FmPro Migrator 2.35 Enterprise Edition for MacOS X and Windows - New Release Adds Repeating Fields Extraction Feature for FileMaker to MySQL Database Migrations.

 

.com Solutions Inc., a developer of multi-platform database migration and development tools, has released FmPro Migrator 2.35 for MacOS X and Windows with a new repeating fields extraction feature for FileMaker Pro to MySQL migrations. Another new feature which has been added is the generation of Perl CGI scripts for FileMaker 7 database migrations.

 

Many FileMaker databases include non-relational data elements called repeating fields. These fields store multiple values within each field and are associated with the main database record by the FileMaker database engine. Manually extracting these repeating fields into a relational database structure can be a time consuming and error-prone process. FmPro Migrator easily extracts FileMaker repeating fields into a separate database table in which the records are related to the main table by the primary key. Each iteration of a FileMaker repeating field is inserted as a new record within the repeating fields table.

 

FmPro Migrator standardizes and automates FileMaker database migration procedures including data type matching, field to column renaming, table creation, FileMaker field size determination and data transfer for 8 different database servers. Supported databases include MySQL, Oracle (8, 8i-9i, 10g), Access, SQL Server, Sybase, DB2, PostgreSQL and FrontBase.

 

FmPro Migrator Features include:

 

-- Repeating Fields Extraction to MySQL - Data from FileMaker repeating fields is now extracted into individual records within a repeating fields table related to the primary database table. Any number of non-container field repeating values are easily extracted to the child table and related to the primary table record by the primary key. Differing numbers of repeating field values are supported for each individual record within the primary database table.

 

-- Repeating Field Table Creation SQL Code Created Automatically - Table creation SQL code is automatically generated for each repeating field within the FileMaker database. Each repeating field table also includes primary key and foreign key constraint code to insure data integrity.

 

-- MacOS X and Windows Compatibility - FmPro Migrator runs on MacOS X and Windows, thus enabling developers to use their preferred platform for creating the migration scripts.

 

FmPro Migrator is available for MacOS X and Windows. A free demo version of FmPro Migrator may be downloaded from www.fmpromigrator.com/downloads/index.html. For more info please see: www.fmpromigrator.com/products/fmpro_migrator

 

About .com Solutions Inc.
.com Solutions Inc. develops multi-platform graphical applications supporting FileMaker, Oracle, MySQL, Access, SQL Server, Sybase, DB2, PostgreSQL and FrontBase developers. FmPro Migrator ( www.fmpromigrator.com ) migrates FileMaker databases to and from FileMaker. Installgen automates over 100 Oracle install procedures on Solaris, Windows, Linux and MacOS X. Repgen generates Oracle replication scripts on Solaris, Windows, Linux and MacOS X. For more information about .com Solutions Inc., please visit www.dotcomsolutionsinc.net.

 

David Simpson
www.fmpromigrator.com

__________________________

Please visit our sponsors:

    RadGad(sm): The Place for Useful Gifts & Gadgets.(sm)
    http://www.radgad.com/, mailto:[EMAIL PROTECTED], or 877-5-RADGAD

    MacTech(r) Magazine: The journal of Macintosh technology and development
    http://www.mactech.com, mailto:[EMAIL PROTECTED], or 805-494-9797

    DevDepot(sm): Your Source for RAM, Technical & Developer Products
    http://www.devdepot.com, mailto:[EMAIL PROTECTED] or call 877-DEPOT-NOW

To submit a posting to MacDev-1, mailto:[EMAIL PROTECTED]  To subscribe to MacDev-1, send mail to [EMAIL PROTECTED] with the SUBJECT line reading "SUBSCRIBE MACDEV-1".  To unsubscribe, the SUBJECT line should read "UNSUBSCRIBE MACDEV-1".

MacTech, Developer Depot, RadGad, and Xplain Corporation are not responsible for any errors, omissions, or other inaccuracies in this message.

News may be propagated freely, but please attribute your source as MacTech Magazine, <http://www.mactech.com>.
--