|
 |
 |
|
|
|
||
|
|
|
2-21-2005 - Fremont, CA - .com Solutions Inc. Releases FmPro Migrator 3.13 Enterprise Edition - New Release for MacOS X and Windows Adds FileMaker to Oracle Repeating Fields Migration Feature. .com Solutions Inc., a developer of multi-platform database migration and development tools, has released FmPro Migrator 3.13 with a new Microsoft Access 2003 to FileMaker 7 migration feature for MacOS X and Windows. FmPro Migrator 3.13 now employs a new FileMaker to Oracle Repeating Fields Migration Feature. 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 New Features and Improvements include: -- Repeating Fields Extraction to Oracle Databases - 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 within the Oracle database. -- Static ODBC DSN Naming for SQL Server Migrations - FmPro Migrator now implements static naming of ODBC DSNs for SQL Server migrations. This improvement means that the ODBC DSNs only need to be set up one time, and can be utilized for each migrated FileMaker database file/table. -- Various Maintenance Fixes Included - FmPro Migrator 3.13 also includes a variety of other maintenance fixes to migration scripts and documentation. These improvements include the use of FileMaker 7 Username/Password info within repeating fields ODBC transfer scripts for all database migrations, and the implementation of a password hiding feature for destination databases. -- 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. A functional 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.
|
|
|
|
|
|
|||||||||||||||
|
|
|||||||||||||||||||||||
|
|
|||||||||||||||||||||||
|
||
|
|
|
|
||
