AdventureWorks 2008 R2 Sample Databases


  • I have downloaded 2008 R2 Adventure family databases EXCEPT Adventureworks2008R2 database , I can see Adventureworks, AdventureworksDW, AdventureworksDW2008R2 databases on object Explorer BUT DIDN'T see Adventureworks2008R2 database, have tried many times but failed.

    Is anyone can hope me to download Adventureworks2008R2 database?




    25 марта 2011 г. 17:58


  • We uploaded an AdventureWorks 2008 R2 OLTP database and script to CodePlex ( Or and click on the SQL Server 2008 R2 OLTP tile.

    Hopefully, this version is easier to attach and use.

    As long as you copy the database to C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\DATA, you should be able to attach the AdventureWorks2008R2_Data.mdf database. You will need to remove the transaction log reference.

    Or you can run the setup script. Follow these steps to install the sample database from the script:

    1. Download AdventureWorks 2008 R2 OLTP (
    2. Copy the DDL script files to any path such {SQL Server Path}\Tools\Samples\AdventureWorks 2008 OLTP Script.

      Note The default SQL Server 2008 R2 path is C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\.
    3. Open {SQL Server Path}\Tools\Samples\AdventureWorks 2008 OLTP\instawdb.sql in SQL Server Management Studio.
    4. Update the script path variables.
    5. If necessary, change the :setvar SqlSamplesDatabasePath variable to your SQL Server 2008 R2 path. The default path is C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA.
    6. Change the :setvar SqlSamplesSourceDataPath variable to the path containing the .csv files.
    7. Uncomment each :setvar variable.
    8. On the Querymenu, click SQLCMD Mode.
    9. On the Standardtoolbar, click the Executebutton to run the script.

    3 апреля 2012 г. 22:25

Все ответы