Primary Key Sync for Multiple Clients upload only

[rhemasystems]

Please how do you handle this case where am syncing one db to the server db, the server db already has 2 records in Sales table with primary keys 1 and 2 from another Client DB1, the new upload from the Client DB2 also has primary key 1 and 2, after syncing the Client DB2, the upload goes to update the two records at the server db belonging to Client DB1 instead of inserting those 2 records making a total of 4 records, 2 records from each Client DB

Not that my Id field is Identity Auto increment Primary keys on both clients and server
Client DB2

Server DB, showing the 2 records belonging to Client DB1 that have been updated by Client DB2 upload

From the screenshot, the new client db has updated the records in the server db instead of inserting.
and this table Sales also has 2 related tables called SalesDetails and SalesPayment

[Mimetis]

that's intended :)
Primary Key 1 on any client will do an update on Server if Primary Key 1 is exsting already on the server

Just change Auto Increment to Guid

[rhemasystems]

Thank you sir, please what exactly do you mean.
Which datatype should I use.
Also what will be the impact on the related tables that have foreign key of this Sales table.

[Mimetis]

Change your primary keys and replace int Identity Auto Increment with UniqueIdentifier (guid)

[rhemasystems]

Thank you Sir,
I get the below error when I try to change the datatype

[Mimetis]

https://learn.microsoft.com/en-us/sql/?view=sql-server-ver16