Oracle's SYS_GUID() vs MS SQL Server NEWID()

From: Uma Muthu <Mail_at_NoCoolSpamBlue.com>
Date: Fri, 22 Aug 2003 19:24:41 GMT
Message-ID: <Z5u1b.6048$Nc.3791467@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.

TIA - ~ Uma Muthu ~

Received on Fri Aug 22 2003 - 14:24:41 CDT