Re: SQL Server for Oracle DBAs

Tony Rogerson wrote:
> This seems a good comparison from a migration from Oracle to SQL Server
> perspective which would be a good starting point...
>
> Solution Guide for Migrating Oracle on UNIX to SQL Server on Windows
> (Chapter 5 - Developing: Databases - Migrating the Database Architecture)
>
> http://www.microsoft.com/technet/solutionaccelerators/cits/interopmigration/unix/oracleunixtosql/or2sql05.mspx

This webpage is near zero-value. An Oracle DBA doing this will be nearly clueless based on the very substantial amount of information that is either incorrect or missing.

Among the obvious factual errors:
"Because an extent is a contiguous allocation of blocks, large extents aid in better I/O rate while reading huge amounts of data."

"Oracle tablespaces are at the instance level."

-- 
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org