Replication and Autonumbers

[Blorf]

Hello.

Is there danger in using Autonumbers as primary keys in a replicated database for syncing?

I ask because the sync process brings in records with huge autonumbers.

Will this lead to issues, or is there some inteligent scheme going on?

Thanks,
ChaZ

There Are 10 Types Of People In The world:
Those That Understand BINARY And Those That Don’t.

 

[Blorf]

Disregard. F1 gave me the following:

If more than 100 records are routinely added between synchronizing replicas, you should use Replication ID for the FieldSize property setting to prevent records from being assigned the same primary key value in each replica. Note, however, that an AutoNumber field with a Replication ID field size produces a 128-bit value that will require more disk space.

Thanks,
ChaZ

There Are 10 Types Of People In The world:
Those That Understand BINARY And Those That Don’t.

 

[evalesthy]

Check this out:

http://support.microsoft.com/kb/q282977/

see section 4 about autonumber