I have a DB to be used in five locations using merge replication. The identity columns were set as Not for replication.
I would like to set up the Seed and Identity increments like this:
Machine 1 has a seed of 1 and an increment of 2 (odd, positive numbers)
Machine 2 has a seed of 2 and an increment of 2 (even, positive numbers)
Machine 3 has a seed of -1 and an increment of -2 (odd, negative numbers)
Machine 4 has a seed of -2 and an increment of -2 (even, negative numbers)
Machine 5 has a seed of 1,000,001 and an increment of 2 (odd, positive numbers starting at 1 million 1)
The DB already has some data in it.
How do I manage the seed and Increment values.
When I created the publications it wont let me change the table,
- Unable to modify table.
ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot drop the table 'dbo.tablename' because it is being used for replication.
I can't set up the distributer with the same increment because it needs to change + - for the subscribers.
I can reseed the db with checkident (tablename, reseed, value) but where do you adjust the increment values?
I am a newbie at this and it was put into my hands as I made the original Access DB. so please be gentle.
Thanks
I would like to set up the Seed and Identity increments like this:
Machine 1 has a seed of 1 and an increment of 2 (odd, positive numbers)
Machine 2 has a seed of 2 and an increment of 2 (even, positive numbers)
Machine 3 has a seed of -1 and an increment of -2 (odd, negative numbers)
Machine 4 has a seed of -2 and an increment of -2 (even, negative numbers)
Machine 5 has a seed of 1,000,001 and an increment of 2 (odd, positive numbers starting at 1 million 1)
The DB already has some data in it.
How do I manage the seed and Increment values.
When I created the publications it wont let me change the table,
- Unable to modify table.
ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot drop the table 'dbo.tablename' because it is being used for replication.
I can't set up the distributer with the same increment because it needs to change + - for the subscribers.
I can reseed the db with checkident (tablename, reseed, value) but where do you adjust the increment values?
I am a newbie at this and it was put into my hands as I made the original Access DB. so please be gentle.
Thanks