Hi, With so many versions of the Adventure Works DB being available as well as samples, is there any body who could explain each download and if appropriate which tutorial it relates to. Sorry if this sounds quite a basic question, but for someone at the beginning of learning SQL Sever each. Hi Peter, I agree that they are overly complex when. SQL Server – How to Download and Install the ‘right’ AdventureWorks Sample Database July 31, 2013 by Suresh Raavi One of the first things I did when I began my journey with SQL Server was installing a sample database.
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.
StepsA summary of what needs to be done is as follows:Install the sample AdventureWorks database onto SQL Server 2012Follow 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 ServicesFollow 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.
These downloads are scripts and full database backups (.bak) files that you can use to install the AdventureWorks (OLTP) and AdventureWorksDW (data warehouse) sample databases to your SQL Server instance.
Note that AdventureWorks has not seen any significant changes since the 2012 version. The only differences between the various versions of AdventureWorks are the name of the database and the database compatibility level.
For additional guidance, please review the instructions for attaching a database and restoring a database.
Install scripts
For AdventureWorks, download AdventureWorks-oltp-install-script.zip, or use the files in the oltp-install-script folder in GitHub.
For AdventureWorksDW, download AdventureWorksDW-data-warehouse-install-script.zip, or use the files in the data-warehouse-install-script folder in GitHub.
AdventureWorks (OLTP) full database backups
AdventureWorks2016_EXT.bak
Download size is 883 MB. This is an extended version of AdventureWorks, designed to showcase SQL Server 2016 features. To see the features in action, run the SQL Server 2016 sample scripts on this database. AdventureWorksLT (Lightweight) full database backupsAdventureWorksDW (Data Warehouse) full database backups
AdventureWorksDW2016_EXT.bak
An extended version of AdventureWorksDW2016 designed to showcase SQL Server 2016 features. To see the features in action, run the SQL Server 2016 sample scripts on this database. Additional OLTP backups and samplesComments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2022
Categories |