question

MWeiberg-3898 avatar image
0 Votes"
MWeiberg-3898 asked MWeiberg-3898 commented

Changing the identity-seed after synchronisation

i am using sql server 17 on laptops and a azure sql database for synchronisation. Each Laptop has its own identityseed for example :

Laptop 1 seed 10000, inkrement 1
Laptop 2 seed 20000, inkrement 2

after a bi-directionale synchronisation the seed of the laptops were changed to the highest id in the database. Is it possible to leave the actually id of the seed while the synchronisation without any scripts or source ?

azure-sql-database
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@MWeiberg-3898 Is Azure SQL the hub and your laptops member databases?
Please provide details on the direction of data sync.

0 Votes 0 ·

Azure is the hub, the laptops are all members. the synchronisation is bidirectional - so all databases must have alle datas.

so problem was :
the database (the tables) of each laptop use its own id (PK). because of using the same ids on the different laptops some datas were delete after synchronisation. So i thing when i am using identity seed every laptop can use its own range of id's. But now after the synchronisation each laptop not use the next id of its range - it uses the next id higher then the highest id in the table.

0 Votes 0 ·

0 Answers