"Uma Muthu" <Mail_at_NoCoolSpamBlue.com> wrote in message
news:Z5u1b.6048$Nc.3791467_at_news1.news.adelphia.net...
> I am working with two databases who share data: an Oracle 9i DB and a MS
SQL
> Server 2000. I am concerned that GUIDs that are generated on one DB may
be
> duplicated ):- on the other DB, and when we go to share data a duplicate
key
> scenario might arise.
>
> Is there any way I can determine the algorithms used to generate the GUIDs
> on both DBs so that I can format them (if I have to) in a way that they
> will
> never collide? I use sys_guid() to generate GUIDs in Oracle, and NewID()
in
> SQL Server.
>
> Any suggestions would be appreciated.
GUID's are 128 bit values, you shouldn't worry about collisions as the
chance of this happening is so fantastically small.
Received on Fri Aug 22 2003 - 15:03:18 CDT
