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.

MirrorSync Config Utility: Foreign key mapping omitted

Featured Replies

Hello, Jesse:

The first show-stopping issue I came across today was that I never got the screen for foreign key mapping, and when I got done, it did not draw any lines between the 17 tables I chose for synchronization.

First screen after selecting the database to be used from the server:

post-105889-0-32558800-1339794048_thumb.

Next screen after selecting the Primary Key and Modification TimeStamp Mapping (skips foreign key mapping totally):

post-105889-0-88752500-1339794042_thumb.

I deleted the previous config, as well as the user that I attempted to setup (in Licensing), quit the utility, then refreshed my browser, downloaded the utility again, clicked "New" (after deleting that user from Licensing again), went through the steps of choosing Primary keys and modificationTimestamps, and it still skips the Foreign key mapping. When I chose "Cancel" at the final screen that says "Database Setup", this is what occurs:

post-105889-0-17107700-1339794034_thumb.

Looking forward to your ideas on how to "fix" this so we can try again to test for deployment.

- - Scott

That is because you're using UUIDs, and UUIDs stay the same on all devices. We only need to configure foreign key mappings when using sequential numbers for primary keys, because those change when they are synced to different devices, and we need to know which foreign key values to update.

Create an account or sign in to comment

Important Information

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

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.