New News Entry - Mailing list pgsql-www
From | www@www.postgresql.com (World Wide Web Owner) |
---|---|
Subject | New News Entry |
Date | |
Msg-id | 20041118002021.CAF417384E2@www.postgresql.com Whole thread Raw |
Responses |
Re: New News Entry
(Josh Berkus <josh@agliodbs.com>)
|
List | pgsql-www |
A new entry has been added to the news database. Database Admin: http://www.postgresql.org/admin/edit_news.php?242 Submitted by: sales@dotcomsolutionsinc.net Headline: FmPro Migrator 2.57 Adds Repeating Fields Extraction Feature for FileMaker to PostgreSQL Conversions Summary: Manually extracting FileMaker repeating fields into a relational database structure can be a time consuming process. FmProMigrator easily extracts FileMaker repeating fields into a separate database table when performing FileMaker to PosgreSQLConversions. Story: 11-17-2004 - Fremont, CA - .com Solutions Inc. releases FmPro Migrator 2.57 Enterprise Edition for MacOS X and Windows -New Release Adds Repeating Fields Extraction Feature for PostgreSQL Database Conversions. .com Solutions Inc., a developer of multi-platform database migration and development tools, has released FmPro Migrator2.57 for MacOS X and Windows with a new repeating fields extraction feature for PostgreSQL database migrations. Many FileMaker databases include non-relational data elements called repeating fields. These fields store multiple valueswithin each field and are associated with the main database record by the FileMaker database engine. Manually extractingthese repeating fields into a relational database structure can be a time consuming and error-prone process. FmProMigrator easily extracts FileMaker repeating fields into a separate database table in which the records are relatedto the main table by the primary key. Each iteration of a FileMaker repeating field is inserted as a new record withinthe repeating fields table. FmPro Migrator standardizes and automates FileMaker database migration procedures including data type matching, field tocolumn 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 PostgreSQL - Data from FileMaker repeating fields is now extracted into individual recordswithin a repeating fields table related to the primary database table. Any number of non-container field repeatingvalues are easily extracted to the child table and related to the primary table record by the primary key. Differingnumbers 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 foreach repeating field within the FileMaker database. Each repeating field table also includes primary key and foreign keyconstraint code to insure data integrity. -- Drop Column Script Created for PostgreSQL - Once the repeating fields data has been migrated to the new repeating fieldstable, the unused columns are no longer needed within the main PostgreSQL database table. These columns are easilyremoved with a drop columns script which is created by FmPro Migrator. The automatic creation of this script by FmProMigrator reduces the possibility of the DBA making errors by writing this script manually. -- MacOS X and Windows Compatibility - FmPro Migrator runs on MacOS X and Windows, thus enabling developers to use theirpreferred 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 databasesto and from FileMaker. Installgen automates over 100 Oracle install procedures on Solaris, Windows, Linux and MacOSX. Repgen generates Oracle replication scripts on Solaris, Windows, Linux and MacOS X. For more information about .comSolutions Inc., please visit www.dotcomsolutionsinc.net.