The schema names are included with the table names and must be specified when performing queries against the tables. Notice that AdventureWorks uses schema names other than dbo. For example, if a query references the Orders table in Northwind, a similar query can be written for AdventureWorks by using the Sales.SalesOrderHeader table.
You can use the following table to convert queries that use Northwind to queries that use AdventureWorks by selecting columns from the appropriate AdventureWorks tables. SQL Server 2008 Some tables in the AdventureWorks sample database are similar in structure and content to tables in the Northwind sample database. Coming off a successful fiscal year, Adventure Works Cycles is looking to broaden its market share by targeting their sales to their best customers, extending their product availability through an external Web site, and reducing their cost of sales through lower production costs.ĪdventureWorks to Northwind Table Comparison In 2001, Importadores Neptuno, became the sole manufacturer and distributor of the touring bicycle product group. These subcomponents are shipped to the Bothell location for final product assembly. Importadores Neptuno manufactures several critical subcomponents for the Adventure Works Cycles product line. In 2000, Adventure Works Cycles bought a small manufacturing plant, Importadores Neptuno, located in Mexico. While its base operation is located in Bothell, Washington with 290 employees, several regional sales teams are located throughout their market base.
The company manufactures and sells metal and composite bicycles to North American, European and Asian commercial markets. SQL Server 2008 Adventure Works Cycles, the fictitious company on which the AdventureWorks sample databases are based, is a large, multinational manufacturing company. Adventure Works Cycles Business Scenarios