Re: Migrating an Application from SQL Server 2000 to Oracle 10g

From: DA Morgan <>
Date: Mon, 21 Jul 2008 18:05:05 -0700
Message-ID: <>

Shakespeare wrote:
> "Michael Austin" <> schreef in bericht
> news:bIygk.33467$

>> One thing I ran into is having to create sequences and triggers for all of 
>> those "auto-increment" data types in SQLServer and MySQL that a lot of 
>> people like to use for the PK... (which IMO is a complete waste of compute 
>> time if the data can be a self-unique PK - but that is just me)

> That's a discussion about meaningles and meaningful (primary) keys - imho,
> data should never be the key itself.
> Shakespeare

Are you ready to go toe-to-toe with Joe Celko and many others and argue that one should never use a natural key?

I certainly hope not.

Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington (replace x with u to respond)
Puget Sound Oracle Users Group
Received on Mon Jul 21 2008 - 20:05:05 CDT

Original text of this message