Where is AdventureWorks2008R2 database?

Question

Hey all,

I downloaded sql2008r2 reporting services samples from http://msftrsprodsamples.codeplex.com/releases/view/72275 and the database samples from http://msftdbprodsamples.codeplex.com/releases/view/55926. When I deployed the project I got an error message because the AdventureWorks2008R2 database did not exist. Checking the databases I installed with the downloaded file I only have AdventureWorks. Could anyone please tell me where I can get  the AdventureWorks2008R2 database so that I can run Reporting Services samples?

Thanks,

Marco 

Answer 1

Use the AdventureWorksLT2008R2 database which is part of the above download

---

Jeff Wharton
MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt), MCT, MCPD, MCITP, MCDBA
Blog: Mr. Wharty's Ramblings
MC ID: Microsoft Transcript

Please mark answered if I've answered your question and vote for it as helpful to help other user's find a solution quicker

Answer 2

A few people have had problems with the link that you and Jeff mentioned.  If it doesn't work, you can also try downloading from

http://msftdbprodsamples.codeplex.com/releases/view/55330

 

Thanks,
Sam Lester (MSFT)

 

---

This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you. This can be beneficial to other community members reading the thread.

Answer 3

check this link

http://msftdbprodsamples.codeplex.com/

Answer 4

We uploaded an AdventureWorks 2008 R2 OLTP database and script to CodePlex (http://msftdbprodsamples.codeplex.com/releases/view/59211). Orhttp://msftdbprodsamples.codeplex.com 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 Script.zip (http://msftdbprodsamples.codeplex.com/releases/view/59211)
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.