In this training we will be using the sample transactional database known as 'AdventureWorks'. This database is provided by Microsoft and is free to download. For more for more info and detailed instruction see the Adventureworks Github page here.

Apr 20, 2017  Install the sample AdventureWorks cube onto SQL Server 2012 Analysis Services Follow these steps: 1. Go to the following CodePlex download page: CodePlex 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. In this tutorial, I will show you where to download the AdventureWorks sample database and import the database to your Microsoft SQL Server 2019 database system (or any version of Microsoft SQL.

Instructions for downloading and installing the AdventureWorks Database:

1. Download the .bak file attached and save it to the C: drive. not in a sub-folder.
2. Open SQL Server Management Studio and connect to your SQL Server instance.
3. Restore the database using the SQL Server Management Studio user interface.
   1. Right-click Databases and select Restore Database..
   2. On the General page, use the Source section to specify the source and location of the backup sets to restore.
   3. Select Device
   4. Click the browse (..) button to open the Select backup devices dialog box.
   5. Click Add
   6. Navigate to the C: drive and select the .bak file.
   7. Click OK in each dialog box until the restore process is completed

A data dictionary for AdventureWorks can be found here: https://www.sqldatadictionary.com/AdventureWorks20..

The Entity Relationship Diagram can be found attached below.

Introduction to SQL Server Sample Databases

To get started with Microsoft SQL Server for demonstrations & training you need some sample databases to play with. There are many sample databases available online on SQL Server across the web. But the official releases are only on the Codeplex website. Users can find it confusing to find the correct version of the sample database. So I compiled a single list of all available SQL Server samples. Please find below, direct links to download SQL Server Sample Databases.

Direct Links To Download SQL Server Sample Databases:

SQL Server 2016 RTM & Beyond:

World Wide Importers OLTP and DW Samples. These samples are suitable for Enterprise Editions or equivalent. (Evaluation/Developer Editions)

Word Wide Importers (WWI) Standard Edition Samples for OLTP and DW.

Azure OLTP Sample for World Wide Importers.

Azure DW Sample for World Wide Importers.

SSIS Samples to Populate Data to WWI Database (OLTP to OLAP)

WWI Sample Scripts.

Adventure Works for SQL Server 2016 CTP3 (Database Engine & Data Warehouse Samples)

SQLServer2016CTP3Samples.zip, File Size 79.2 MB, 883.3 MB, 6.4 MB respectively.

Azure SQL Database Sample(Database Engine)

Download here: AdventureWorks2012ForWindowsAzureSQLDatabase

Learn more about Azure SQL Database Restore Method.

Adventure Works for SQL Server 2014 (Database Engine)

Restore using Backup & Restore Method: Adventure Works 2014 Full Database Backup.zip

Download OLTP Script: Adventure Works 2014 OLTP Script.zip

Adventure Works for SQL Server 2014 (Data Warehouse)

Download Data Warehouse Sample Adventure Works 2014 Warehouse Script. (Restore by running the T-SQL Scripts)

Download SQL Server Analysis Services Sample Adventure Works Multidimensional Model SQL 2014 Full Database Backups.

Back File for Multidimensional Models SQL Server 2014

Note: You need SQL Server Data Tools (SSDT) or Business Intelligence Templates installed. Use Analysis Services Project to deploy to Analysis Server Multi-Dimensional Service.

Pre-Requisites: Adventure Works 2014 Full Database

Download SQL Server Analysis Services Tabular Model Adventure Works Internet Sales Tabular Model 2014 Backup.zip.

Note: You need SQL Server Data Tools (SSDT) or Business Intelligence Templates installed. Use Analysis Services Project to deploy to Analysis Server Tabular Service.

Pre-Requisites: Adventure Works 2014 Full Database

Download Adventure Works Internet Sales Tabular Model 2014 Backup file.

Note: You need SQL Server Data Tools (SSDT) or Business Intelligence Templates installed. Use Analysis Services Project to deploy to Analysis Server Multi-Dimensional Service.

Pre-Requisites: Adventure Works 2014 Full Database

Adventure Works for SQL Server 2012 (Database Engine)

Download OLTP Database AdventureWorks2012 Data File (Restore using Database Attach method)

Restore using Backup & Restore Method: AdventureWorks2012-Full Database Backup.zip

Download OLTP Script: AdventureWorks 2012 OLTP Script

Adventure Works for SQL Server 2012 (Data Warehouse)

Download Data Warehouse Sample AdventureWorksDW2012 Data File (Restore using Database Attach method)

Download SQL Server Analysis Services Sample AdventureWorks Multidimensional Models SQL Server 2012

Note: You need SQL Server Data Tools (SSDT) or Business Intelligence Templates installed. Use Analysis Services Project to deploy to Analysis Server Multi-Dimensional Service.

Pre-Requisites: AdventureWorksDW2012

Download SQL Server Analysis Services Tabular Model AdventureWorks Tabular Model SQL Server 2012.

Note: You need SQL Server Data Tools (SSDT) or Business Intelligence Templates installed. Use Analysis Services Project to deploy to Analysis Server Tabular Service.

Pre-Requisites: AdventureWorksDW2012

Download AdventureWorks Internet Sales Tabular Model SQL Server 2012

Note: You need SQL Server Data Tools (SSDT) or Business Intelligence Templates installed. Use Analysis Services Project to deploy to Analysis Server Multi-Dimensional Service.

Pre-Requisites: AdventureWorksDW2012

Adventure Works for SQL Server 2012 LT (Compact Edition)

Download AdventureWorksLT2012_Data (Restore using Database Attach method)

Description: This is a compact version of Adventure works 2012 OLTP Sample.

Adventure Works for SQL Server 2008 (Database Engine)

Download OLTP Database AdventureWorks2008R2 Data File (Restore using Database Attach method)

Restore using Backup & Restore Method: AdventureWorks2008R2-Full Database Backup.zip

Download OLTP Script: AdventureWorks 2008R2 OLTP Script

Adventure Works for SQL Server 2008 (Data Warehouse)

One thing extended mix mr. belt wezel jack wins zippyshare. Download Data Warehouse Sample AdventureWorksDW2008R2 Data File (Restore using Database Attach method) Download will you marry me jason de rulo.

Download SQL Server Analysis Services Sample AdventureWorksDW2008R2 cube for SSAS 2008 R2

Note: You need SQL Server Data Tools (SSDT) or Business Intelligence Templates installed. Use Analysis Services Project to deploy to Analysis Server Multi-Dimensional Service.

Pre-Requisites: AdventureWorksDW2012

Adventure Works for SQL Server 2008 LT (Compact Edition)

Download AdventureWorks 2008R2 LT Data File (Restore using Database Attach method)

Description: This is a compact version of Adventure works 2008 OLTP Sample.

Download them here Northwind & Pubs.

Disclaimer: The Questions and Answers provided on https://www.gigxp.com are for general information purposes only. We make no representations or warranties of any kind, express or implied, about the completeness, accuracy, reliability, suitability or availabilitywith respect to the website or the information, products, services, or related graphics contained on the website for any purpose.