Tutorial eBooks PDF File Download

This whitepaper explains the key differences between Microsoft® SQL Server™ 2005 databases and Oracle databases. It compares SQL Server and Oracle database architecture and provides information on the newest features in SQL Server 2005. This paper is intended for Oracle professionals who want to leverage their Oracle knowledge to manage SQL Server or prepare to migrate an Oracle database to SQL Server 2005. Other topics discussed in this white paper include backups, database security, management options and high availability options. Database Architecture In Oracle, a database refers to the entire Oracle RDBMS environment and includes the following components: • Oracle database processes and buffers (instance). • SYSTEM tablespace containing one centralized system catalog, which is made up of one or more datafiles. • Other optional tablespaces as defined by the database administrator (DBA), each made up of one or more datafiles. • Two or more online Redo Logs. • Archived Redo Logs (optional). • Miscellaneous files (control file, Init.ora, Config.ora, and so on).