• Phil Parkin - Thursday, June 29, 2017 8:58 AM

    alladiz - Thursday, June 29, 2017 8:55 AM

    Thanks Bill for these questions (making me think more 🙂 ). I have provided the answers to the best of my knowledge. Thanks again!!
    Are there only five tables to be synchronized? Yes, as of now.
    Are the five tables constrained by foreign keys...so inserts must be done parent to child and deletes done from child to parent? I am not sure about this as of now.
    Are each of the ten users owners of their data...so other users cannot change it and cause merge failures? possibility of other users changing the data
    Is this a two way sync where data changes come down and go up? It will always be from local to central
    Can all data for a user be deleted and refreshed from the laptop up to the server in a brute force way?I don't think so.

    This answer
    "It will always be from local to central"
    conflicts with this
    "possibility of other users changing the data"

    How would a user ever change another user's data if data is only ever sync'd inwards?

    Sorry for the incorrect info. The data movement will be bi-directional.