Conflict management - take both client and server changes?

[spj-uk]

Is it possible when resolving conflicts to keep both items e.g.

Server: ID 2 Name "Bob"
Client: ID 2 Name "Jo"

Presumably ID would need to be changed / incremented and then inserted somehow.

[Mimetis]

hello @spj-uk
I'm sorry, you can use the Merge option when dealing with conflicts, but to be in sync, both rows should have the same value

[spj-uk]

Thanks for replying. To confirm I want both rows in the synchronised database rather than to merge the records. i.e. Client ID 2 would have to become a new record with ID as it's a primary key. Is this possible?

[Mimetis]

DMS will not be able to do that.

[VagueGit]

The client must ensure unique ids. That's why DMS recommends using guids. It is possible to use sequential integer identifiers, but you will need an algorithm to generate identifiers that ensures uniqueness across devices even when disconnected.

[Mimetis]

Take a look here : #590