For the sake of simplicity and consistency, all references to the sample database will be to AdventureWorks2008 only. An Oracle database provides you with better scalability, reliability, increased performance, and better security than third-party databases. With this caveat in mind, all the query examples shown in the book will work with both versions, unless specified otherwise, but queries run with the 2005 version may return different results from those shown in this book. When that was not possible, we either wrote two sets of examples, one for SQL Server 2005 and the other for SQL Server 2008, or we built views to emulate the table structure of SQL Server 2005 in SQL Server 2008. I originally posted this logic in an Oracle Technology Network article on Essbase Studio. The USE statement tells SSMS what database to operate on. Oracle-AdventureWorks/README at master artofbi/Oracle-AdventureWorks This is a Microsoft to Oracle port of the well known AdventureWorks database. AdventureWorks have replaced Northwind and Pubs from the sample database in SQL Server 2005. AdventureWorks is a Sample Database shipped with SQL Server and it can be downloaded from GitHub site. otdata.sql is for loading data into the tables. otschema.sql is for creating database objects such as tables, constraints, etc. sql files: otcreateuser.sql is for creating OT user and grant privileges. For the most part, we have attempted to use tables in our examples that are the same in structure in both SQL versions. Open up the AdventureWorks database and retrieve either the sales order information for customer 1 (first query) or in the 2nd query one months of data records from the SalesOrderHeader table. If you are using SQL Server there are good chances that you are familiar with AdventureWorks. After downloading the file, you should extract it.

To accommodate for these differences, we have done one of three things. The version that installs with SQL Server 2005 is slightly different from the version installed with SQL Server 2008. There have actually been several different versions of this database as it evolved from the first edition in 2004 and then through the SQL Server 2008 CTP test period. This database, called Adventure Works with SQL Server 2005 and AdventureWorks2008 with SQL Server 2008, is a sample database included with SQL Server. Through the remainder of the book, you'll be working with a database used by the fictitious company Adventure Works Cycles, which sells bicycles and related products.

Oracle adventureworks database