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

Uma Muthu wrote:
>
> 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 ~

Tag the oracle rows with a sequence starting at 1 Tag the sql server rows with a "sequence" starting at 1000,000,000

should be fine for the first billion rows

hth
connor

-- 
=========================
Connor McDonald
http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue"