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

Top 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... | Read more »
Price of Glory unleashes its 1.4 Alpha u...
As much as we all probably dislike Maths as a subject, we do have to hand it to geometry for giving us the good old Hexgrid, home of some of the best strategy games. One such example, Price of Glory, has dropped its 1.4 Alpha update, stocked full... | Read more »
The SLC 2025 kicks off this month to cro...
Ever since the Solo Leveling: Arise Championship 2025 was announced, I have been looking forward to it. The promotional clip they released a month or two back showed crowds going absolutely nuts for the previous competitions, so imagine the... | Read more »
Dive into some early Magicpunk fun as Cr...
Excellent news for fans of steampunk and magic; the Precursor Test for Magicpunk MMORPG Crystal of Atlan opens today. This rather fancy way of saying beta test will remain open until March 5th and is available for PC - boo - and Android devices -... | Read more »
Prepare to get your mind melted as Evang...
If you are a fan of sci-fi shooters and incredibly weird, mind-bending anime series, then you are in for a treat, as Goddess of Victory: Nikke is gearing up for its second collaboration with Evangelion. We were also treated to an upcoming... | Read more »
Square Enix gives with one hand and slap...
We have something of a mixed bag coming over from Square Enix HQ today. Two of their mobile games are revelling in life with new events keeping them alive, whilst another has been thrown onto the ever-growing discard pile Square is building. I... | Read more »
Let the world burn as you have some fest...
It is time to leave the world burning once again as you take a much-needed break from that whole “hero” lark and enjoy some celebrations in Genshin Impact. Version 5.4, Moonlight Amidst Dreams, will see you in Inazuma to attend the Mikawa Flower... | Read more »
Full Moon Over the Abyssal Sea lands on...
Aether Gazer has announced its latest major update, and it is one of the loveliest event names I have ever heard. Full Moon Over the Abyssal Sea is an amazing name, and it comes loaded with two side stories, a new S-grade Modifier, and some fancy... | Read more »
Open your own eatery for all the forest...
Very important question; when you read the title Zoo Restaurant, do you also immediately think of running a restaurant in which you cook Zoo animals as the course? I will just assume yes. Anyway, come June 23rd we will all be able to start up our... | Read more »
Crystal of Atlan opens registration for...
Nuverse was prominently featured in the last month for all the wrong reasons with the USA TikTok debacle, but now it is putting all that behind it and preparing for the Crystal of Atlan beta test. Taking place between February 18th and March 5th,... | Read more »

Price Scanner via MacPrices.net

AT&T is offering a 65% discount on the ne...
AT&T is offering the new iPhone 16e for up to 65% off their monthly finance fee with 36-months of service. No trade-in is required. Discount is applied via monthly bill credits over the 36 month... Read more
Use this code to get a free iPhone 13 at Visi...
For a limited time, use code SWEETDEAL to get a free 128GB iPhone 13 Visible, Verizon’s low-cost wireless cell service, Visible. Deal is valid when you purchase the Visible+ annual plan. Free... Read more
M4 Mac minis on sale for $50-$80 off MSRP at...
B&H Photo has M4 Mac minis in stock and on sale right now for $50 to $80 off Apple’s MSRP, each including free 1-2 day shipping to most US addresses: – M4 Mac mini (16GB/256GB): $549, $50 off... Read more
Buy an iPhone 16 at Boost Mobile and get one...
Boost Mobile, an MVNO using AT&T and T-Mobile’s networks, is offering one year of free Unlimited service with the purchase of any iPhone 16. Purchase the iPhone at standard MSRP, and then choose... Read more
Get an iPhone 15 for only $299 at Boost Mobil...
Boost Mobile, an MVNO using AT&T and T-Mobile’s networks, is offering the 128GB iPhone 15 for $299.99 including service with their Unlimited Premium plan (50GB of premium data, $60/month), or $20... Read more
Unreal Mobile is offering $100 off any new iP...
Unreal Mobile, an MVNO using AT&T and T-Mobile’s networks, is offering a $100 discount on any new iPhone with service. This includes new iPhone 16 models as well as iPhone 15, 14, 13, and SE... Read more
Apple drops prices on clearance iPhone 14 mod...
With today’s introduction of the new iPhone 16e, Apple has discontinued the iPhone 14, 14 Pro, and SE. In response, Apple has dropped prices on unlocked, Certified Refurbished, iPhone 14 models to a... Read more
B&H has 16-inch M4 Max MacBook Pros on sa...
B&H Photo is offering a $360-$410 discount on new 16-inch MacBook Pros with M4 Max CPUs right now. B&H offers free 1-2 day shipping to most US addresses: – 16″ M4 Max MacBook Pro (36GB/1TB/... Read more
Amazon is offering a $100 discount on the M4...
Amazon has the M4 Pro Mac mini discounted $100 off MSRP right now. Shipping is free. Their price is the lowest currently available for this popular mini: – Mac mini M4 Pro (24GB/512GB): $1299, $100... Read more
B&H continues to offer $150-$220 discount...
B&H Photo has 14-inch M4 MacBook Pros on sale for $150-$220 off MSRP. B&H offers free 1-2 day shipping to most US addresses: – 14″ M4 MacBook Pro (16GB/512GB): $1449, $150 off MSRP – 14″ M4... Read more

Jobs Board

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