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 (a
href=”http://www.fmpromigrator.com/downloads/index.html”)(font
size=”-1″)www.fmpromigrator.com/downloads/index.html(/a)(font
size=”-1″). For more info please see: (a
href=”http://www.fmpromigrator.com/products/fmpro_migrator”)(font
size=”-1″)www.fmpromigrator.com/products/fmpro_migrator(/a)(/div
)
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 ( (a
href=”http://www.fmpromigrator.com”)(font
size=”-1″)www.fmpromigrator.com(/a) ) 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 (a href=”http://www.dotcomsolutionsinc.net”)(font
size=”-1″)www.dotcomsolutionsinc.net(/a)(font
size=”-1″).
David Simpson
(a href=”http://www.fmpromigrator.com”)(font
size=”-1″)www.fmpromigrator.com(/a)