Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQLServer db with GUID migration

183812Aug 25 2003 — edited Aug 28 2003

Hi,

In the application db that I need to migrate ( using the latest version of owb ) GUID's are used as primary keys. Oracle consistently maps the SQLServer datatype "uniqueidentifier" to a number(8,0) and only allows to change the size of the number. However when specifying uniqueidentifier in SQLServer as Global uniqueidentifiers, values are actually hexadecimal values that can be mapped to char(36) data strings ( ie. {DC2AE15F-7D74-400D-9516-959B0C61A854})

Does anyone have any experience and/or workaround for this?

Thanks in advance

Brian Underhill

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 25 2003

Added on Aug 25 2003

#database-and-application-migrations

1 comment

3,849 views