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!

uniqueidentifier - sql server

99690Mar 10 2005

There is a doc #272908.1 on metalink saying about migration of uniqueidentifier.

My sql server database is on windows2000 and document says...
" For SQL Server databases running on Windows2000 the method to generate unique identifiers is different. Uniqueness *cannot* be guaranteed for migrated and new data based on the Physical Address of the network card of the system on which the database server is running. INSERT statements need to be added to the migrated code to catch unique key violations and retry the INSERT in case of failure. "

can anybody explain the case and show the method to migrate the data uniquely and any method to keep them unique for future data Inserts?

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 7 2005

Added on Mar 10 2005

#database-and-application-migrations

0 comments

396 views