"rg" <rg01@[EMAIL PROTECTED]
> wrote in
news:#kfRzk#TIHA.1208@[EMAIL PROTECTED]
> Question (1) - What are your opinions on using Replication Id as
> the Field Size rather than a Long Integer in a Key Field linking
> two tables?
No, ReplicationID is not a good idea. Here's why:
http://trigeminal.com/usenet/usenet011.asp?1033
> Question (2) - If there is a need/recommendation to change the
> Field Size to Replication Id, how do I convert the existing
> records to a Replication Id value?
Don't.
I didn't quite get what your issue was? Is it just fear of colliding
primary keys? I wouldn't worry about that. I've had replicated
applications out there since 1997 and have never used anything but
Random Autonumbers and have not once seen a collision.
In any event, a collision is just going to be treated as a conflict
and should be resolvable programatically.
--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
