Jump to content
View in the app

A better way to browse. Learn more.
FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Merging Remote and Local copies of a database with multiple tables

iamthegrey
in Importing & Exporting

Featured Replies

I have a local server based version of a filemaker database that all of our inside sales and support people run, but out sales people also take a copy of this database with them on the road as a runtime solution. There are 4 main tables in this database get updated by our people on the road. Meanwhile the people back at HQ are also modifying the data. So the question is twofold - what is the best way to merge these two databases together or 2) is there a better way to build the database with a minimal amount of tables to make the merging process streamlined. RIght now I do it by script based on record ID number and modification date, but sometimes one record is being modified both at HQ and on the road and when the merge happens - something gets lost from one side or the other. Any advice would be appreciated.

Best option: get rid of the runtime copies and get the sales people to connect to the main database through mobile broadband.

Synchronisation is difficult, and it gets complicated mighty fast.

Look into the SyncDek solution.

http://www.worldsync.com/syncdek/

Create an account or sign in to comment

https://fmforums.com/topic/72402-merging-remote-and-local-copies-of-a-database-with-multiple-tables/
Go to topic listing

Important Information

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

I accept

Configure browser push notifications
Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.