Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

Readme_Installing Sample Databases from Script

SQL Server 2005

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.

  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.

  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.

  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.

Community Additions

ADD
Show:
© 2015 Microsoft