-->
If you want data warehouses, then choose & Download Adventure Works DW 2014 Full Database Backup.zip Click the Save button to Download AdventureWorks Database Once the download completed, please unzip the file.
The AdventureWorks database is a fictitious company database that has existed since SQL Server 2005 as a means to show new functionality in each new version released. Because the Books Online TSQL samples leverage this sample database, AdventureWorks has become a vital aspect of learning new features/constructs within SQL Server. What started as a big improvement over the Northwind and Pubs sample databases has evolved into numerous specialized off-shoots highlighting different aspects of the product. There are now multiple versions of AdventureWorks databases for each version of the product, including many updates corresponding to service pack releases. The end result is that it is extremely confusing to find the 'correct' version of AdventureWorks that you are searching for. I'll lovingly refer to this as AdventureWorks sprawl and try to lower the barrier to entry for getting started working with the AdventureWorks sample database.
Pre-SQL Server 2005:
AdventureWorks did not exist before SQL Server 2005. In this time, the sample databases Northwind and Pubs were included on the media along with the product and could be installed during the setup process. You can download the Northwind and Pubs sample databases for SQL Server 2000 here.
SQL Server 2005:
In the SQL Server 2005 timeframe, the AdventureWorks sample DB was introduced and also included on the media along with the product. You can install the samples during setup or download them from the following location:
The installers for SQL Server 2005 supply you with the .mdf/.ldf files, but you need to manually attach them to your instance for use. You will see a couple different AdventureWorks databases, each with a slightly different focus. For the majority of people downloading sample databases to learn T-SQL, refer to Books Online examples, etc., the AdventureWorksDB is the first one to start with.
SQL Server 2008:
Beginning with SQL Server 2008, the sample databases are no longer included with the media and must be downloaded and attached as a separate step. The SQL Server 2008 sample databases are packaged slightly different than any other version, where they include a single .exe file that will allow you to install all different versions of the SQL Server 2008 sample databases. They also include a .zip file containing a single .mdf and .ldf for attaching the basic AdventureWorksLT database. I'd suggest unzipping this file and attaching the .mdf/.ldf to get started and using the .exe if you want to dig further into more complex examples.
Step-by-step instructions for using the .exe to install all sample DBs is here.
SQL Server 2008 R2:
Beginning with the 2008 R2 sample databases, a new version was introduced that supported filestream. If you are familiar with SQL Server and trying to learn filestream specifically, you'll want to download the version containing filestream sample schema/code. For the huge bulk of users trying to leverage the sample database to learn the basics and extend into new areas, you will want to download the version without filestream support from the link below:
In this link, you will see numerous versions of the database. To get started quickly, I'd suggest downloading AdventureWorks2008R2-Full Database Backup.zip, unzipping the .bak file to your backup location, and restoring the database through SSMS. The other versions all have different intentions for learning, but again I'd suggest starting with the basic version first before advancing to the other versions.
SQL Server 2012:
Through the evolution of the AdventureWorks DBs over the years, the site hosting the sample databases now includes 13 different links/flavors/versions of the sample database for SQL Server 2012 and can be found here:
As with my suggestion for 2008 R2, I would suggest that you download AdventureWorks2012-Full Database Backup.zip, unzip the .bak file to your backup location, and restore the database through SSMS to get started quickly.
SQL Server 2014:
Following the same pattern as with 2008 R2 and 2012, you can download Adventure Works 2014 Full Database Backup.zip, unzip the .bak file to your backup location, and restore the database through SSMS to get started quickly.
In summary, the AdventureWorks sample databases are outstanding learning tools for understanding examples from Books Online, trying out new constructs, and exploring entire new areas of SQL Server, but wading through the numerous versions and editions can be quite confusing. If you have questions/comments, let me know.
Hope this helps,
Sam Lester (MSFT)
Sam Lester (MSFT)
Skip to end of metadataGo to start of metadata
Purpose
The purpose of this page is to describe where to obtain the sample Adventureworks database and multidimensional database (cube) as well as describe the process of bringing them into SQL Server 2012.
Steps
A summary of what needs to be done is as follows:
Install the sample AdventureWorks database onto SQL Server 2012
Follow these steps:
1. Go to the following CodePlex download page:
2. Click on “SQL Server 2012 OLTP” and you will be directed to the Downloads page for SQL Server 2012.
3. Click on the “AdventureWorksDW2012 Data File” so that the “AdventureWorksDW2012_Data.mdf” file is downloaded.
4. Copy the “AdventureWorksDW2012_Data.mdf” file to the Microsoft SQL Server DATA folder as follows:
C:Program FilesMicrosoft SQL ServerMSSQL11.MSSQLSERVERMSSQLDATA
5. Launch Microsoft SQL Server Management Studio and select 'Server Type' = 'Database Engine'.
6. Click 'Connect'.
7. Right-click “Databases” and click “Attach”.
8. Click “Add” and select the “AdventureWorksDW2012_Data.mdf” database.
9. Click 'OK'.
10. Remove the “AdventureWorks2012_Log.ldf” file by clicking the “Remove” button.
11. Click 'OK'. Now the AdventureWorks database is attached.
Install the sample AdventureWorks cube onto SQL Server 2012 Analysis Services
Follow these steps:
1. Go to the following CodePlex download page:
2. Click on “SQL Server 2012 OLTP” and you will be directed to the Downloads page for SQL Server 2012. Choose the “AdventureWorks Multidimensional Models SQL Server 2012” download. The result is that a file called “AdventureWorks Multidimensional Models SQL Server 2012.zip” is download.
Put it in, for example, location 'C:AdventureWorks Cube'.
3. Unzip the “AdventureWorks Multidimensional Models SQL Server 2012.zip” file.
4. Right-click on the ' “AdventureWorks Multidimensional Models SQL Server 2012' folder and click on 'Properties'.
5. Uncheck the 'Read-only' property and then click 'OK'.
6. A confirmation screen is shown to 'Apply changes to this folder, subfolders and files'.
7. Go into the 'Enterprise folder. Notice that there is a file called 'AdventureWorksDW2012Multidimensional-EE.sln'.
8. Double-click on the 'AdventureWorksDW2012Multidimensional-EE.sln' file to open it in Visual Studio 2010.
9. If prompted to enter the default environment settings for Visual Studio 2010, select 'Business Intelligence Settings'.
10. Click 'Start Visual Studio' and the AdventureWorks solution will be opened in VS2010.
11. Open up the 'AdventureWorksDW2012.ds' file by double-clicking on it.
12. Click 'Edit' the 'Connection string' to launch the 'Connection Manager'.
13. Log on to the server by entering your credentials and select the AdventureWorksDW2012 database to connect to.
14. Test the connection by clicking 'Test Connection'. Assuming that the connection is successful, the following screen will be shown:
15. Click 'OK'.
16. On the 'Data Source Designer' page, click on the 'Impersonation' tab. Confirm that 'Use the service account' has been selected. If not, change it to that. Then click 'OK'.
17. Show the 'Deployment Progress' window by selecting 'View' - 'Show Deployment Progress'.
The 'Deployment Progress' section is shown.
18. Deploy the 'Adventureworks DW2012Multidimensiona-lEE' multidimensional database. Right-click on 'Adventureworks DW2012Multidimensiona-lEE' and then click 'Deploy'.
19. The 'Deployment Progress' view will show the status of the deployment including whether or not the deployment was successful.
20. Now if you look in SQL Server Management Studio, you will see that the cube is deployed.
In SQL Server Management Studio, select 'File' - 'Connect Object Explorer'.
After clicking 'Connect', you will now see that the 'AdventureWorksDW2012Multidimensional-EE' analysis database is now shown.