Oracle and SQL Server GUIDs

From: Jimmy Ringo <ringosoft_at_MailAndNews.com>
Date: Tue, 13 Feb 2001 14:11:52 -0500
Message-ID: <3A8CFCCE@MailAndNews.com>

I am working with two databases who share data: an Oracle 8i DB and a MS SQL Server 7 DB. 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 advice is appreciated.

---

 Get your FREE web-based e-mail and newsgroup access at:

                http://MailAndNews.com

 Create a new mailbox, or access your existing IMAP4 or  POP3 mailbox from anywhere with just a web browser.

---

Received on Tue Feb 13 2001 - 13:11:52 CST