New News Entry - Mailing list pgsql-www

A new entry has been added to the news database.

Database Admin: http://www.postgresql.org/admin/edit_news.php?181

Submitted by: sales@dotcomsolutionsinc.net
Headline: FmPro Migrator 1.97 - Adds FileMaker to PostgreSQL Migration Feature
Summary:

Database administrators can use FmPro Migrator to convert a FileMaker Pro database to PostgreSQL in order to scale up
databasesolutions for higher capacity and functionality. 

Story:

4-21-2004 - Fremont, CA - .com Solutions Inc. releases FmPro Migrator 1.97 Enterprise Edition for MacOS X and Windows -
NewRelease Adds FileMaker to PostgreSQL Migration Feature 

.com Solutions Inc., a developer of multi-platform database development tools, has released FmPro Migrator 1.97 for
MacOSX and Windows with a new FileMaker to PostgreSQL migration feature. Converting a FileMaker Pro database to
PostgreSQLenables developers to scale up database solutions for higher capacity and functionality. Well regarded as the
world\'smost advanced open source relational database system, the PostgreSQL database incorporates functionality such
asstored procedures, foreign keys, user defined types, functions and operators. These enhanced features are not
currentlyavailable within other open source databases. PostgreSQL is also available for a wide variety of operating
systems,thus giving IT departments wide flexibility concerning deployment hardware. 

FmPro Migrator standardizes and automates the migration process including data type matching, field to column renaming,
tablecreation, FileMaker field datasize determination and data transfer. The data transfer from FileMaker to PostgreSQL
isperformed via an ODBC connection between the two databases in order to maintain accuracy and provide for the
migrationof images and large text fields. FileMaker container field images are migrated to PostgreSQL \"lo\" (large
objecttype) columns which are fully supported by the PostgreSQL ODBC driver. 

New Features of FmPro Migrator include:
-- Scale up FileMaker Databases to PostgreSQL - PostgreSQL offers performance and functionality improvements over
FileMakerdatabase files. PostgreSQL incorporates a rich feature set including, stored procedures, triggers, and
replicationof data for high availability.  

-- Migrate All FileMaker Data Types to PostgreSQL - FmPro Migrator utilizes PostgreSQL\'s user defined type capability
tomigrate FileMaker container fields to the commonly supported \'lo\' (binary large object) column type. This user
definedtype is fully supported by the PostgreSQL ODBC driver and is included as a standard feature with Mammoth
PostgreSQLdistributions.  

-- Improvements to FileMaker to FileMaker 7 migrations - Additional FileMaker 7 reserved words have been incorporated
withinFmPro Migrator 1.97. The addition of these reserved words means that fewer table creation errors will occur when
buildingFileMaker 7 database tables.  

-- Full Functionality for FmPro Migrator Demo Edition - The latest demo edition of FmPro Migrator is now fully
functionalfor a limited number of database fields. This enhanced functionality means that potential customers can fully
testall FmPro Migrator features prior to making a purchase decision. 

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\">www.fmpromigrator.com/downloads/index.html</a>.<BR>For more
infoplease see: <a
href=\"http://www.fmpromigrator.com/products/fmpro_migrator\">www.fmpromigrator.com/products/fmpro_migrator</a>

About .com Solutions Inc.
.com Solutions Inc. develops multi-platform graphical applications supporting FileMaker, Oracle, MySQL, Access, SQL
Server,Sybase, DB2 and PostgreSQL developers. FmPro Migrator ( <a
href=\"http://www.fmpromigrator.com\">www.fmpromigrator.com</a>) migrates FileMaker databases to and from FileMaker.
Installgen( www.installgen.com ) automates over 100 Oracle install procedures on Solaris, Windows, Linux and MacOS X.
Repgengenerates Oracle replication scripts on Solaris, Windows, Linux and MacOS X. For more information about .com
SolutionsInc., please visit www.dotcomsolutionsinc.net.