X

Join or Sign In

Sign in to add and modify your software

Continue with email

By joining Download.com, you agree to our Terms of Use and acknowledge the data practices in our Privacy Policy.

Developer's Description

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


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 also makes it useful as a tool for FM->SQL migration.

Full Specifications

What's new in version 2.0b12

Features specific to FileMaker v7 compatibility
  • account name and password options
  • layout name option, custom names for 'update' & 'select' layout (needed for multiple table support)
  • field names options, custom names for primary_key, last_mod & last_synch fields
General Improvements
  • streamlined interface, much easier to manage and edit configurations
  • last_synch timestamp now saved for each record rather than each table, better accuracy in finding modified data (records don't have to be processed twice for borderline cases)
  • improved support for MS SQL databases
  • change FM field setup from repeating field to portal, allows virtually unlimited number of fields for each configuration
  • configuration groups, synching configs can be grouped together and run at different times
  • multiple SQL/JDBC configurations, each synching config can use a different SQL database or connection
  • debugging tools, help find cause of invalid data errors due to type mismatch or validation restrictions on 'update' layouts
  • configurable sort order for configs during synch run
  • minor changes to Demo files to support new feature for v2
  • option to specify field separator (eg. pipe "|") used by SQL Plugin for select queries
  • added config for minimum seconds between last_synch and last_mod (defaults to 1 second)
  • date format now uses 'system settings' rather than asking which to use when different
  • improvements to error handling; synching process should be more robust
  • partial support for running via FileMaker Server
  • updated documentation pages (documentation for v2 still incomplete)
Bug Fixes
  • improved error handling for event handlers
  • reset error count when running more than one synch in a single session
  • misc bug fixes related to last_synch and last_mod field comparisons
  • misc bug fixes

General

Release August 25, 2008
Date Added January 7, 2006
Version 2.0b12

Operating Systems

Operating Systems Mac OS X 10.4 PPC, Macintosh, Mac OS X 10.3, Mac OS X 10.0, Mac OS X 10.2, Mac OS X 10.3.9, Mac OS X 10.1
Additional Requirements SQL Plugin (demo included with fmSQL Synch)
JDBC driver for your database
FileMaker 7.x or higher

Popularity

Total Downloads 51
Downloads Last Week 0
Report Software

Related Software

Nerdtool

Free
Nerdtool

ShiftIt

Free
ShiftIt

eDrawings Viewer 2015

Free
eDrawings Viewer 2015

Screen Crosshair

Free
Screen Crosshair

Best VPN Services for 2021

Best for privacy

3 months free with 1-year plan

Best for customer support

$39.99 for the first 12 months

Best for zero logs

$4.87.99/months for a 1-year plan

Best money-back guarantee

$2.99/months for a 3-year plan