Readme_Installing Sample Databases from Script

  • Article

These are instructions for installing the AdventureWorks sample databases by running the appropriate installation script from SQL Server Management Studio Query Editor. The installation script removes the existing sample database, re-creates the database objects, and populates the tables. Alternatively, you can download the AdventureWorks database at the SQL Server Developer Web site.

To install AdventureWorks OLTP from script:

  1. From the Management Studio tool bar, click File, point to Open and then click File.

  2. Browse to C:\Program Files\Microsoft SQL Server\90\Tools\Samples\AdventureWorks OLTP, select the file instawdb.sql and click Open.

  3. Before running the script, locate the statement SET @data_path = @sql_path + 'AWDB\'; in the script and change the statement to SET @data_path = 'c:\Program Files\Microsoft SQL Server\90\Tools\Samples\AdventureWorks OLTP\'

  4. Run the script.

To install AdventureWorks Data Warehouse from script:

  1. From the Management Studio tool bar, click File, point to Open and then click File.

  2. Browse to C:\Program Files\Microsoft SQL Server\90\Tools\Samples\AdventureWorks Data Warehouse, select the file instawdwdb.sql and click Open.

  3. Before running the script, locate the statement SET @data_path = @sql_path + 'awdwdb\'; in the script and change the statement to SELECT @data_path = 'c:\Program Files\Microsoft SQL Server\90\Tools\Samples\AdventureWorks Data Warehouse\';.

  4. Run the script.

To Deploy AdventureWorks OLAP:

  1. Ensure the AdventureWorksDW and AdventureWorksAS databases have been installed.

  2. Ensure Analysis Services has been installed.

  3. From the Business Intelligence Development Studio tool bar, click File, point to Open and then click Project/Solution.

  4. Browse to C:\Program Files\Microsoft SQL Server\90\Tools\Samples\AdventureWorks Analysis Services Project, select the file Adventure Works DW.dwproj and click Open.

  5. From Solution Explorer, right-click Adventure Works DW and select Deploy.