MySQL to FileMaker, SQL Server Migration

MySQL to FileMaker Graphic

FmPro Migrator 9.48 - improves the reading of SQL Server tables.

Top 10 Features

Quickly transfers SQL Server and MySQL database tables and data into FileMaker Pro.
Straightforward 3 step process migrates tables and data locally, using FmPro Migrator.
Use open source, public and commercial schema and data in FileMaker Pro solutions.
Import WordPress schema and data into FileMaker Pro.
Import Microsoft Dynamics SQL Server tables in FileMaker Pro projects.
Edit data in FileMaker Pro and update SQL databases via 3rd party mirroring products.
Perform online/offline data editing using FileMaker Pro for desktop and mobile apps - sync when connected.
Skip IT scheduling bottlenecks by moving SQL database apps into FileMaker Pro solutions.
Save money and reduce errors without manual data entry of large data sets.
Full UTF-8 data compatibility from source to destination database transfers.

For more info please send email or call.

FmPro to Servoy Migration screenshot

Description

The MySQL and SQL Server to FileMaker Pro conversion features included in FmPro Migrator enable fast and easy schema importing from popular SQL database servers. This feature prevents manual data entry errors and ensures full UTF-8 data transfer compatibility. Data and schema from public, open source and private data sources can serve as the starting point for building or enhancing FileMaker Pro solutions. It is also possible to build desktop or mobile FileMaker solutions having data sync capability back to the original SQL database server.

The features and benefits of using the SQL to FmPro Feature include:

Reuse existing schema and data - Existing open source and public data sources can serve as the starting point for new fully customized FileMaker solutions. Once the schema and data has been imported into FileMaker, the solution can be fully customized to meet the unique needs of your new application.

Save money by moving applications from more expensive SQL database applications and online services into your own private applications running in FileMaker Pro.

Improve and customize the workflow of larger applications which the IT department might not have time to work into their development schedule. Features, bug fixes and enhancements can often be implemented in FileMaker Pro in a fraction of the time and resources required for a typical SQL database application.

Import a locally editable copy of data from popular open source projects like WordPress into FileMaker Pro. A local database copy provides offline access to the data even when you aren't connected to the internet.

Provide online/offline sync of mobile and desktop apps with SQL database servers using the FmPro Migrator Batch Transfer Utility or other data mirroring products. FmPro Migrator Batch Transfer Utility provides an economical automated data transfer utility from FileMaker Pro to your SQL database of choice.

Step #1 - Get Info

Step #1 - Get Info from MySQL

Step #1 of the migration process is to enter the source database connection parameters, then click the Step #1 button. FmPro Migrator will display a progress dialog while reading the metadata from the source database (MySQL is shown here).

Step #2 - Create Tables

Step #2 - Create Tables in FileMaker Pro

Once the table info has been imported into FmPro Migrator, click the Copy All Tables to Clipboard button. The table creation XML code will be put onto the clipboard, ready to be pasted into FileMaker Pro.

Step #3 - Transfer Data

Clicking the Step #3 button transfers the data from the SQL database into FileMaker Pro.

UTF-8 Compatibility


MySQL UTF-8 Characters	FileMaker UTF-8 Characters
FmPro Migrator connects to each database using UTF-8 in order to insure that all characters are transferred accurately between databases. Alternate data transfer methods might not retain all character formatting.

Quickly Transfers SQL Database Tables and Data

Imported tables in FileMaker Pro

FmPro Migrator makes a connection to each database to quickly transfer data into FileMaker Pro tables.

Utilize FileMaker Pro Development Features

FileMaker Edit Relationship Dialog

Quickly create relationships, calculated fields, layouts and scripts in FileMaker Pro to implement any desired workflow features within your solution. Relationships can easily be created manually within the FileMaker Pro database based upon the imported schema.

Demo Mode

The free trial version of FmPro Migrator processed 5 fields and an unlimited number of records.

Using the demo mode at no charge, enables FileMaker Pro developers to become familiar with the conversion process and see the tables and data imported into the FileMaker database.