SQL Server Articles, SQL Server Tips, SQL Server Tutorials, SQL Server Tuning, SQL Server DBA, SQL Server Basics, Training, etc - MyTechMantra.com

How to Download WideWorldImporters Sample Database and Restore in SQL Server 2016

Microsoft has introduced a new sample database WideWorldImporters specifically for SQL Server 2016. Let us take a look at how to download and restore SQL Server 2016 WideWorldImporters Sample Database.

Steps to Download and Restore WideWorldImporters Sample Database are mentioned in this article.

Microsoft has released the Release to Manufacturing (RTM) version of SQL Server 2016 on June 1, 2016. The good news is that you can download SQL Server 2016 Developer Edition for Free. For more information, read How to Download SQL Server 2016 Developer Edition for Free

Different editions of SQL Server 2016

Different editions of SQL Server 2016 which are available are Enterprise, Standard, Web, Developer and Express Edition.

What is WideWorldImporters Sample Database in SQL Server 2016?

WideWorldImporters is a sample database exclusively built for SQL Server 2016 and Azure SQL Database. It can be used to understand core capabilities of SQL Server 2016 and Azure SQL Database, for transaction processing (OLTP), data warehousing and analytics (OLAP) workloads, as well as hybrid transaction and analytics processing (HTAP) workloads.

Links to Download WideWorldImporters Database and SQL Server 2016 Developer Edition for Free

There are two types of WideWorldImporters Database available for download.

Primary Set: This works on Evaluation, Developer and Enterprise Edition of SQL Server 2016 and it supports all features of the product.

SQL Server Evaluation/Developer/Enterprise Edition

  • WideWorldImporters-Full.bak – full sample database for OLTP (Online Transaction Processing) and HTAP (hybrid transaction and analytical processing aka real-time operational analytics). For SQL Server 2016 (or higher) Evaluation/Developer/Enterprise Edition.
  • WideWorldImportersDW-Full.bak – full sample database for OLAP (Online Analytical Processing). For SQL Server 2016 (or higher) Evaluation/Developer/Enterprise Edition.

Secondary Set: This which works on Standard Edition and it supports all features specific to SQL Server 2016 Standard Edition.

SQL Server Standard Edition

Azure SQL Database

SQL Server Integration Services

  • Daily.ETL.ispac – SSIS package for ETL from the OLTP to the OLAP database. Works for both the Full and the Standard versions of the databases.

SQL Server Example

  • sample-scripts.zip – sample scripts illustrating the use of various SQL Server features in the WideWorldImporters sample databases.
  • workload-drivers.zip – sample workloads for the WideWorldImporters sample databases. These are Windows Form applications that will only run on Windows (in this release).

How to Restore WideWorldImporters Sample Database in SQL Server 2016

Use the below sample TSQL Script to restore full backup of WideWorldImporters database in SQL Server 2016. Make necessary changes to the script with respect to location of database files before executing the script.

RESTORE FILELISTONLY
FROM DISK = 'G:\SQLServer2016SampleDBs\WideWorldImporters-Full.BAK'
 
RESTORE Database WideWorldImporters
FROM DISK = 'G:\SQLServer2016SampleDBs\WideWorldImporters-Full.BAK'
WITH
MOVE 'WWI_Primary' TO 'G:\MSSQL\DATA\WideWorldImporters.mdf',
MOVE 'WWI_UserData' TO 'G:\MSSQL\DATA\WideWorldImporters_UserData.ndf',
MOVE 'WWI_Log' TO 'G:\MSSQL\DATA\WideWorldImporters.ldf',
MOVE 'WWI_InMemory_Data_1' TO 'G:\MSSQL\DATA\WideWorldImporters_InMemory_Data_1',
RECOVERY, STATS = 10

Trending SQL Server Articles and Tips

How to Restore WideWorldImportersDW Sample Database in SQL Server 2016

Use the below sample TSQL Script to restore full backup of WideWorldImportersDW database in SQL Server 2016. Make necessary changes to the script with respect to location of database files before executing the script.

RESTORE FILELISTONLY
FROM DISK = 'G:\SQLServer2016SampleDBs\WideWorldImportersDW-Full.BAK'
 
RESTORE Database WideWorldImportersDW
FROM DISK = 'G:\SQLServer2016SampleDBs\WideWorldImportersDW-Full.BAK'
WITH
MOVE 'WWI_Primary' TO 'G:\MSSQL\DATA\WideWorldImportersDW.mdf',
MOVE 'WWI_UserData' TO 'G:\MSSQL\DATA\WideWorldImportersDW_UserData.ndf',
MOVE 'WWI_Log' TO 'G:\MSSQL\DATA\WideWorldImportersDW.ldf',
MOVE 'WWIDW_InMemory_Data_1' TO 'G:\MSSQL\DATA\WideWorldImportersDW_InMemory_Data_1',
RECOVERY, STATS =10

Conclusion

We recommend you to download and install WideWorldImporters sample database to play around with the data and to learn more about New T-SQL Enhancements in SQL Server 2016.

References

Chetna Bhalla

LESS ME MORE WE

Chetna Bhalla, the founder of MyTechMantra.com, believes that by sharing knowledge and building communities, we can make this world a better place to live in. Chetna is a Graduate in Social Sciences and a Masters in Human Resources and International Business. She is an alumnus of Vignana Jyothi Institute of Management, Hyderabad, India. After graduation, Chetna founded this website, which has since then become quite a favorite in the tech world. Her vision is to make this website the favorite place for seeking information on Databases and other Information Technology areas. She believes that companies which can organize and deploy their data to frame strategies are going to have a competitive edge over others. Her interest areas include Microsoft SQL Server and overall Database Management. Apart from her work, Chetna enjoys spending time with her friends, painting, gardening, playing the violin, and spending time with her son.

Newsletter Signup! Join 15,000+ Professionals




Be Social! Like & Follow Us

Follow us

Don't be shy, get in touch. We love meeting interesting people and making new friends.

Advertisement