New - FileMaker Repeating Fields
Migration Feature
The FmPro Migration Service provides a fixed-price migration
of FileMaker Pro databases to a wide variety of destination databases.
Database migration target databases include MySQL, Oracle, Access,
Microsoft SQL Server, Sybase, DB2, PostgreSQL, FrontBase, SQLite,
Valentina and FileMaker Pro 20. The FmPro Migration Service utilizes
FmPro Migrator Developer
Edition to provide an automated, high-quality migration process
for JPEG images, large text fields and numeric data.
For more info please send email or call.
Need to upgrade FileMaker Pro 2,3,4,5,6 to FileMaker
Pro 20? Please see the info about the FmPro
Upgrade Service.
The features and benefits of using the FmPro Migration
Service include:
Fixed
Price Service - You know up front what the cost will be to migrate
your FileMaker Pro database. Pricing for the migration of each FileMaker
Pro database.
This price includes schema design for the destination database, data
extraction/import, export and delivery to the customer. Output file
formats are based upon the appropriate standardized format commonly
used for each destination database (as shown in the table
below).
Repeating
Fields Extraction - 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 software. Manually extracting these
repeating fields into a relational database structure can be a time
consuming and error-prone process. Manually re-keying these records
is not practical for many databases due to the number of records which
need to be transferred. The FmPro Migration Service can be enhanced
with this repeating fields extraction feature in order to extract
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. This add-on to the standard FmPro
Migration Service costs $150 per FileMaker database file/table.
Experience
- .com Solutions Inc. is a FileMaker Business Alliance member with
over 20 years of FileMaker Pro development experience. This experience
spans FileMaker revisions 1.0 thru 20, Oracle 8.0.5 thru 11g, SQL
Server, MySQL 5.7, MariaDB 11 and DB2 8.1, PostgreSQL
9, and SQLite 3.
Automated
Procedures Improve Accuracy - Manual database migration procedures
can take days or even weeks and introduce errors in database structure
and records. FmPro
Migrator Developer Edition is used to automate time consuming
and complex database migration tasks. Furthermore, there is no manual
re-keying of data required during any phase of the migration process.
Improved
Scalability - FileMaker Pro is optimized for workgroup applications
with generally fewer than 999 simultaneous users. Migrating FileMaker
Pro data to MySQL, Oracle, Microsoft SQL Server, Sybase or DB2 leverages
existing investments in these highly scalable databases capable of
handling thousands of simultaneous users.
FileMaker
ESS - FileMaker Pro 9+versions include the External SQL Sources feature
which enables the use of external SQL data sources within FileMaker
solutions. Even though the data is stored within an external SQL data
source, can be made available for queries, reporting and data entry
within FileMaker layouts. E xisting FileMaker ScriptMaker scripts,
layouts and calculations can operate on migrated data residing within
SQL data sources.
Multi-Platform
Experience - .com Solutions Inc. has extensive experience with database
servers hosted on MacOS X, Windows, Solaris and Linux. The FmPro Migration
Service provides a very economical alternative to purchasing and supporting
additional computer hardware.
Multi-Database
Experience - .com Solutions Inc. has years of experience working with
different database servers hosted on multiple platforms. Customers
benefit from extensive training and real-world experience which may
not be available from their in-house IT department. Not having to
hire additional employees or high-priced consultants on an hourly
basis can also quickly add up to big savings for IT budgets.
Customers with special data confidentiality needs may
request alternate migration procedures in order to avoid sending their
proprietary data off-site. These options include a scripts-only service,
or customer use of the specialized version of FmPro Migrator software
which is utilized by this service. Please send email
or call for details.
The following table summarizes the databases and output
formats which are supported by the FmPro Migration Service:
|
FmPro
Migration Service Supported Databases
|
| Database |
Output Format |
| Oracle 8.1.7, 9.2.0, 10g, 11g, 12c |
Export file (*.DMP) |
| MySQL 5.7 |
raw data files or export file |
| Access 97, 2003, 2007, 2010, 2016 |
*.mdb data file |
| SQL Server |
database backup file (.bak) |
| Sybase Sybase 12.5 |
bcp Export |
| DB2 8.1 |
PC/IXF Export |
| PostgreSQL 16 |
pg_dump file |
| SQLite 3 |
binary data file |
