Right. If tables B and C reference table A, and A will need to be replicated, A's physical primary key should be the GUID column.
It would probably be easier to make a blanket statement that replicated tables' primary keys should be GUIDs. :-) On Wed, 8 Dec 2004 11:47:42 -0600, Schreck, Tom <[EMAIL PROTECTED]> wrote: > A dual key scenario would require one of the keys (the GUID) to be the > master identity. In this situation, would you still use the GUID as the > foreign key? I would think so because if you need to move data from dev to > stg to produciotn, you would have to have the GUID as the foreign key. > Otherwise you run the risk of the INT identity value being used in your > target environment. > > > > Thanks > > Tom Schreck > 972-361-9943 > > -----Original Message----- > From: Steve Runyon [mailto:[EMAIL PROTECTED] > Sent: Wednesday, December 08, 2004 10:38 AM > To: [EMAIL PROTECTED] > Subject: Re: [CFCDev] GUIDs as Primary/Foreign Keys > > I'll throw my 2 cents in on the side of GUIDs for replication, INTs > otherwise, but here's something to note: if you're generating lists > with 100's of rows, using GUIDs exclusively can substantially increase > the weight of your generated html. That's typically not an issue for > developers, but it could be for your users if they're on slow > connections. > > For tables you need to be able to replicate, consider having two > candidate keys, a GUID and an INT. (Which one is the physical PK is > dependent on how easily you need to replicate references to the > table.) When generating html, use the INT instead of the GUID. > ---------------------------------------------------------- > You are subscribed to cfcdev. To unsubscribe, send an email > to [EMAIL PROTECTED] with the words 'unsubscribe cfcdev' > in the message of the email. > > CFCDev is run by CFCZone (www.cfczone.org) and supported > by Mindtool, Corporation (www.mindtool.com). > > An archive of the CFCDev list is available at > [EMAIL PROTECTED] > ---------------------------------------------------------- > You are subscribed to cfcdev. To unsubscribe, send an email > to [EMAIL PROTECTED] with the words 'unsubscribe cfcdev' > in the message of the email. > > CFCDev is run by CFCZone (www.cfczone.org) and supported > by Mindtool, Corporation (www.mindtool.com). > > An archive of the CFCDev list is available at > [EMAIL PROTECTED] > ---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to [EMAIL PROTECTED] with the words 'unsubscribe cfcdev' in the message of the email. CFCDev is run by CFCZone (www.cfczone.org) and supported by Mindtool, Corporation (www.mindtool.com). An archive of the CFCDev list is available at [EMAIL PROTECTED]
