Jump to content
Sign in to follow this  

Collecting database info to home office.

Recommended Posts

Would someone please point me in the right direction?

I have 19 offices that all have standalone FM databases. I would like to collect all updates to their databases on a daily basis to a central, home office database. The offices only have dial-up internet connections. I am sure that solutions to this have alrady been worked out, and I don't want to reinvent the wheel. Any suggestions where to start looking for ideas?

Share this post

Link to post
Share on other sites

Database synchronisation is always a difficult (and nasty) piece of work. It's far better to avoid doing it by centralising the database.

Create a script in each database that exports the daily additions and changes. Get the users to e-mail this file to you.

Share this post

Link to post
Share on other sites

RE: dialup

I'd imagine that dialup is the main issue since it is a slow, non-persistant internet connection. IMO, what you want requires a persistent, preferably fast internet connection, or it's a hassle. Vaughan's suggestion of a centralized db is the way to go. Host the main db in your office and everyone else just connects remotely.

Steve's reference to SyncDek looks good but seems to require an e-mail account at each "node" to do the syncronization so the dialup still might be an issue. Good to know such a thing exists, though. Thanx, Steve!


Share this post

Link to post
Share on other sites

Thanks for your comments.

I am concerned that having a centralized database will be too slow as the company expands. I see 50 offices all trying to access the database and it just bogging down to a standstill.

Does anyone have any experience with this size central database?

Share this post

Link to post
Share on other sites

1. Switch to FM7. Performance across a WAN is much better.

2. The SyncDek solution is a good solution if you want to sync disconneced data.

3. No personal experience but for this sort of thing Citrix is supposed to be an outstanding solution. The heavy lifting is done on one centralized box (or a few, given your user count) and performance is great according to all who use this method.

4. Will a web interface work?

Share this post

Link to post
Share on other sites


I use SyncDeK to synchronise 20+ databases at 4 different remote locations. It works great, you do need certain things for the plugin to work, i.e Windows 2000/XP or Mac OS X.3, with the latest Java and an email account for each node.

The only problem I find, is when I make updates to one database (interface/structure etc), I have to make the same updates three times, a pain. There is a "Version Update Manager" module with this plugin, theoretically where I can update one database and "Sync" the updated files to the other nodes, but I'm not too confident of that feature.

Regarding BruceR's post, I dont know what WAN performance is like with FM7, but with FM6 its really slow, and in truth unworkable....and the rumours I've heard from our developer group they havn't made FM7 that much better., although I haven't used this feature myself.

Ideally, I would urge you to setup terminal services and buy a FM VLA licence. that way data is centralised, hence one data store and one machine "processing" the data. Dialup access to the server would be fine, as terminal services is a vector based "display" solution which doesn't take much bandwidth, you can use a web browser on your remote machines to access the centralized data.

Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

  • Similar Content

    • By Tumma K
      Hello, All!

      I am an aspiring developer for Filemaker. The company I work with is stuck in the past working off of Filemaker Pro 4.1

      I was given the task of bringing us up to Filemaker Pro/Server 13. So far my conversion prototypes are successful but we recently had a layout issue that can only be fixed in versions 3-6 (as the file is an .fp3) I work off of a macbook while our network is all Windows 7. In order for me to repair the layouts without tampering our active database, I decided the best option is to repair a copy of our solutions off the network. Unfortunately, when I go to download the trial version of Filemaker Pro 6 off of the respected website, the file is corrupt! I've tried multiple times, with different extraction apps and in different directories.

      My question is;

      Does anyone know a place where I could obtain version 6 (or better yet, 4.0) for an OSX computer? I've looked everywhere!
      Thank you for your time,
      Tumma K.
    • By MrEddByrnes
      I'm hoping my question can have a happy ending. In the mid-90's, I purchased Filemaker 3. When Filemaker 5.5 Pro was released, I bought the update CD, which requires the user to either have FM 3 installed or to have the installation CD for FM 3. I've used it all these years, most recently with Windows XP Pro, and it has worked just fine. The databases I began with were long ago converted to FM Pro 5.5 databases.
      I'm still using FM Pro 5.5 on a laptop with WinXP Pro, but in 2013, I purchased a PC with Windows 8. I haven't been able to install FM 3 on it, therefore can't install FM Pro 5.5. I am retired and rarely use Filemaker, but I have a few Filemaker databases I'd like to add to my Win 8 machine. I don't feel it's worth upgrading FM for the sake of using a couple of databases.
      Has anyone else run into this situation and/or have a (possible) solution? Is there perhaps any other software that can read FM 5.5 databases? Thanks in advance for your help.
    • By bmill
      I am using a custom filemaker solution for medical office billing written with fp5 running on a mac with snow leopard. In addition, I have a patient management db (which I wrote) that is linked through pt. ID number to the billing program allowing transfer of some demographic information (name, DOB, etc).
      Other than being limited by hardware restrictions, the billing program serves our needs for now and upgrading to fp12 will take some time (and money).  In the meantime, I am upgrading my pt. management program to fp13 and would like to move new patient demographic information from the billing program ( fp5 running on snow leopard through Parallels) and the new pt management program ( fp13 running on OS X 10.9) on the same mac.   
      Ideally, demographic information would be entered once into fp5 and then a scipt would make the data available for fp13.
      Any ideas on how to make this work?
    • By randyinla
      Hi, can anyone tell me why my on-line database might have stopped allowing me to delete records?  All of my access privileges and passwords are correct.
    • By randyinla
      Hi, I still use filemaker 5.5 and am very happy with it and don't want to upgrade.  Does anyone still host filemaker 5.5?  Thanks!
  • Who Viewed the Topic


Important Information

By using this site, you agree to our Terms of Use.