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)

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

25% OFF PROMOTION Use Promocode: APRIL25OFF

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)

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

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.

Sample Databases for SQL Server 2000

Download them here Northwind & Pubs.