fmSQL Synch (v2.0)

Introduction

fmSQL Synch is a utility to synchronize data from your FileMaker and SQL databases. Data is compared on a record by record as well as field by field basis. Existing databases can be configured for synchronizing with just a few modifications. fmSQL Synch can also be used to migrate data to/from FileMaker and SQL databases.

Features

Two-way synchronizing

You can synchronize data from both FileMaker and SQL databases. Synchronizing includes updating changed records as well as adding or deleting records. Any changes made in your FileMaker databases are also made in your SQL database and vice-versa.

Field level conflict checking and resolution

Changes to records in both databases is compared on a field-by-field basis. Any records that have been modified on both FileMaker and SQL database since the last synchronization will have all change conflicts logged so you can choose which data you want to keep.

Setup Assistant

fmSQL Synch has been designed to be easy to use. The setup assistant will walk you through the steps of configuring up for your environment.

Easily integrates with existing FileMaker solutions

A few extra modifications to your existing FileMaker databases is all that you need to do. Once modified you can synchronize your FileMaker and SQL databases and control all merge conflicts.

Will create all the SQL statements for you automatically

After selecting which fields you want to synchronize in your SQL tables, you can have fmSQL Synch create all the SQL statements automatically. You can even let fmSQL Synch create the SQL tables for you which makes it useful as a FM->SQL migration as well.

System Requirements

• OSX 10.2 or later
• FileMaker Pro v7 or later
• SQL Plugin v2.1.4 or later
• JDBC driver for your SQL database

WARNING!!
This software makes changes to data in both SQL and FileMaker databases. It will change field values and delete & add records as part of the synching process. Make sure you have full backups before testing with important data. Garrison Computer Services takes no responsibility for any loss of data.