Sample Enterprise Data Warehouse

Sample Enterprise Data Warehouse

SQL Server 2000

The enterprise data warehouse is a sample database schema published by Silverston, Inmon, and Graziano, and licensed for use with Microsoft® SQL Server™ 2000. This sample includes definitions of tables frequently used when implementing models of an enterprise data warehouse.

Default Location

C:\Program Files\Microsoft SQL Server\

Running the Samples
  1. In SQL Server Enterprise Manager, create a database to store the sample schema elements.

  2. In SQL Query Analyzer, run Dwent_tables.sql to create the tables, and then run Dwent_constraints.sql to create primary and foreign key constraints.

  3. In SQL Server Enterprise Manager, open the database you just created to view the contents.

See Also

Database Schema Samples

© 2015 Microsoft