fmSQL Synch: Synchronize FileMaker and SQL field-by-field
TweetFollow Us on Twitter

fmSQL Synch: Synchronize FileMaker and SQL field-by-field

FOR IMMEDIATE RELEASE

GARRISON COMPUTER SERVICES ANNOUNCES UPDATED FMSQL SYNCH V1.0.1 FOR
REPLICATED AND DISTRIBUTED DATABASES

Synchronize FileMaker and SQL (web) databases on field-by-field basis

SYDNEY, Aust. - April 6, 2005 - Garrison Computer Services today announced
an update of fmSQL Synch, a replication and synchronizing utility which
updates records in both a FileMaker and SQL database. Available for Mac OS
9 and Mac OS X, fmSQL Synch employs AppleEvents and JDBC to exchange data
between FileMaker and SQL databases.

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.

Two-way synchronizing will update data from both FileMaker and SQL
databases. Synchronizing includes updating changed records as well as
adding or deleting records. Any record changes made in the FileMaker
databases are replicated in the SQL database and vice-versa.

fmSQL Synch employs field-level conflict checking and resolution. Changes
to records in both databases are 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 the user
can choose which data to keep.

fmSQL Synch has been designed to be easy to use. The setup assistant will
walk the user through the required configuration steps, including setting
up the JDBC connection details and choosing which fields to use from each
table.

Easily integrate existing FileMaker solutions with a few extra
modifications to any existing databases. Once modified the user can use
fmSQL Synch to synchronize FileMaker and SQL databases and control all
synching conflicts.

After selecting which fields to synchronize in the SQL tables, the user can
have fmSQL Synch create all the SQL statements automatically. The user can
even let fmSQL Synch create the SQL tables which also makes it useful as a
tool for FM to SQL migration.

"Companies have found cost savings in using a separate web database and are
looking for ways to exchange data with both their web database and their
in-house database" said Charlie Garrison, founder of Garrison Computer
Services. "fmSQL Synch was developed to make that data exchange easy and
reliable."

"The updated fmSQL Synch app worked flawlessly today. Tried couple of times
as I did before, I can not break the synchronization. Besides my testings,
the fmSQL Synch synchronization has kept pace with our Production users
throughout the day. Needless to say, I am ecstatic."
--Henry Chang, Pentagon Technologies

CHANGES IN LATEST VERSION

fmSQL Synch v1.0.1 has a few new features as well as some bug fixes:

- Added DEBUG logging to assist with finding 'set data' errors
- Added support for varying SQL date formats (eg. mySQL, MS SQL, etc)
- Bug fixes & additional support for US vs int'l date formats
- Change IDParent in MergeConflicts and DeleteLog from type 'number' to 'text'
- Updated documentation

PRICING AND AVAILABILITY

fmSQL Synch is available now in two versions; with and without a license for
SQL Plugin. The bundle with a license for the SQL Plugin is on special until
May 15.

- fmSQL Synch, single-user US$129
- fmSQL Synch with SQL Plugin, single-user US$149

To download a demo or for purchasing options, please visit the company's web
site at http://www.garrison.com.au/products/fmsql_synch.html, send email to
sales@garrison.com.au, or call +61 2 4575 5247.

REQUIREMENTS

- OS9 or OSX 10.2 or later
- FileMaker Pro v4 or later (not compatible with FMv7 until fmSQL Synch v2)
- SQL Plugin v2.1.2 or later
- JDBC driver for the SQL database

Note: fmSQL Synch v2 is fully compatible with FMv7. Version 2 is in final
beta testing and a public beta will be released in a few weeks.

The SQL Plugin from Rumora Automatisering en Advies is required. The latest
version (at this time) is SQL Plugin 2.1.4. The plugin is commercial
software but a demo version is available for testing fmSQL Synch. A demo
copy of the plugin is included in the fmSQL Synch package. A version of
fmSQL Synch bundled with SQL Plugin is available.

A JDBC driver for the SQL database is also required. fmSQL Synch has been
developed for use with mySQL but any database which has a JDBC driver
should work. The latest version (at this time) is MySQL Connector/J 3.0.15.
The driver is free to download and its use is licensed under the GPL. The
mySQL driver has been included in the fmSQL Synch package for convenience.

ABOUT GARRISON COMPUTER SERVICES

Garrison Computer Services develops web applications and database solutions
for small to medium sized businesses. The company has specialized in
automating Macintosh software and systems since 1987. Other products from
the company include Make Tracks, a customizable FileMaker template for
marketing and customer service databases, and Email Archiver, a tool for
keeping the size of mailboxes to a reasonable limit. For more information,
please visit the company's web site at http://www.garrison.com.au/, send
email to info@garrison.com.au, or call +61 2 4575 5247.

 

Community Search:
MacTech Search:

Software Updates via MacUpdate

Latest Forum Discussions

See All

Six fantastic ways to spend National Vid...
As if anyone needed an excuse to play games today, I am about to give you one: it is National Video Games Day. A day for us to play games, like we no doubt do every day. Let’s not look a gift horse in the mouth. Instead, feast your eyes on this... | Read more »
Old School RuneScape players turn out in...
The sheer leap in technological advancements in our lifetime has been mind-blowing. We went from Commodore 64s to VR glasses in what feels like a heartbeat, but more importantly, the internet. It can be a dark mess, but it also brought hundreds of... | Read more »
Today's Best Mobile Game Discounts...
Every day, we pick out a curated list of the best mobile discounts on the App Store and post them here. This list won't be comprehensive, but it every game on it is recommended. Feel free to check out the coverage we did on them in the links below... | Read more »
Nintendo and The Pokémon Company's...
Unless you have been living under a rock, you know that Nintendo has been locked in an epic battle with Pocketpair, creator of the obvious Pokémon rip-off Palworld. Nintendo often resorts to legal retaliation at the drop of a hat, but it seems this... | Read more »
Apple exclusive mobile games don’t make...
If you are a gamer on phones, no doubt you have been as distressed as I am on one huge sticking point: exclusivity. For years, Xbox and PlayStation have done battle, and before this was the Sega Genesis and the Nintendo NES. On console, it makes... | Read more »
Regionally exclusive events make no sens...
Last week, over on our sister site AppSpy, I babbled excitedly about the Pokémon GO Safari Days event. You can get nine Eevees with an explorer hat per day. Or, can you? Specifically, you, reader. Do you have the time or funds to possibly fly for... | Read more »
As Jon Bellamy defends his choice to can...
Back in March, Jagex announced the appointment of a new CEO, Jon Bellamy. Mr Bellamy then decided to almost immediately paint a huge target on his back by cancelling the Runescapes Pride event. This led to widespread condemnation about his perceived... | Read more »
Marvel Contest of Champions adds two mor...
When I saw the latest two Marvel Contest of Champions characters, I scoffed. Mr Knight and Silver Samurai, thought I, they are running out of good choices. Then I realised no, I was being far too cynical. This is one of the things that games do best... | Read more »
Grass is green, and water is wet: Pokémo...
It must be a day that ends in Y, because Pokémon Trading Card Game Pocket has kicked off its Zoroark Drop Event. Here you can get a promo version of another card, and look forward to the next Wonder Pick Event and the next Mass Outbreak that will be... | Read more »
Enter the Gungeon review
It took me a minute to get around to reviewing this game for a couple of very good reasons. The first is that Enter the Gungeon's style of roguelike bullet-hell action is teetering on the edge of being straight-up malicious, which made getting... | Read more »

Price Scanner via MacPrices.net

Take $150 off every Apple 11-inch M3 iPad Air
Amazon is offering a $150 discount on 11-inch M3 WiFi iPad Airs right now. Shipping is free: – 11″ 128GB M3 WiFi iPad Air: $449, $150 off – 11″ 256GB M3 WiFi iPad Air: $549, $150 off – 11″ 512GB M3... Read more
Apple iPad minis back on sale for $100 off MS...
Amazon is offering $100 discounts (up to 20% off) on Apple’s newest 2024 WiFi iPad minis, each with free shipping. These are the lowest prices available for new minis among the Apple retailers we... Read more
Apple’s 16-inch M4 Max MacBook Pros are on sa...
Amazon has 16-inch M4 Max MacBook Pros (Silver and Black colors) on sale for up to $410 off Apple’s MSRP right now. Shipping is free. Be sure to select Amazon as the seller, rather than a third-party... Read more
Red Pocket Mobile is offering a $150 rebate o...
Red Pocket Mobile has new Apple iPhone 17’s on sale for $150 off MSRP when you switch and open up a new line of service. Red Pocket Mobile is a nationwide MVNO using all the major wireless carrier... Read more
Switch to Verizon, and get any iPhone 16 for...
With yesterday’s introduction of the new iPhone 17 models, Verizon responded by running “on us” promos across much of the iPhone 16 lineup: iPhone 16 and 16 Plus show as $0/mo for 36 months with bill... Read more
Here is a summary of the new features in Appl...
Apple’s September 2025 event introduced major updates across its most popular product lines, focusing on health, performance, and design breakthroughs. The AirPods Pro 3 now feature best-in-class... Read more
Apple’s Smartphone Lineup Could Use A Touch o...
COMMENTARY – Whatever happened to the old adage, “less is more”? Apple’s smartphone lineup. — which is due for its annual refresh either this month or next (possibly at an Apple Event on September 9... Read more
Take $50 off every 11th-generation A16 WiFi i...
Amazon has Apple’s 11th-generation A16 WiFi iPads in stock on sale for $50 off MSRP right now. Shipping is free: – 11″ 11th-generation 128GB WiFi iPads: $299 $50 off MSRP – 11″ 11th-generation 256GB... Read more
Sunday Sale: 14-inch M4 MacBook Pros for up t...
Don’t pay full price! Amazon has Apple’s 14-inch M4 MacBook Pros (Silver and Black colors) on sale for up to $220 off MSRP right now. Shipping is free. Be sure to select Amazon as the seller, rather... Read more
Mac mini with M4 Pro CPU back on sale for $12...
B&H Photo has Apple’s Mac mini with the M4 Pro CPU back on sale for $1259, $140 off MSRP. B&H offers free 1-2 day shipping to most US addresses: – Mac mini M4 Pro CPU (24GB/512GB): $1259, $... Read more

Jobs Board

All contents are Copyright 1984-2011 by Xplain Corporation. All rights reserved. Theme designed by Icreon.