SQL SERVER 2016 – How to Import New Sample Database WideWorldImporters

Few days back I wrote blog about SQL Server 2016 Developer Edition free download. If you didn’t get a chance to have a look, here is the link. Download SQL SERVER 2016 Developer Version for FREE. Let us learn about how to install Sample Database WideWorldImports.

In that blog, I also said that, here is a new sample database called WideWorldImporters. This database is a replacement of old sample database called AdventureWorks (Engine version) and AdventureWorksDW (Data Warehouse version)

Here is the link to download latest version of the sample database Wide World Importers sample database v1.0

Once you go to the page, you would find various files to download. Here is the quick list about few of them which you would be using.

The reason there are two for the standard edition separately is because there are many features which are not available in standard edition. If you try to “full” on the standard edition, you will not be able to open the database.

Here is the command which you can use to restore the database. Note that I have created a folder called C:\WideWorldImporters-Full. I have kept a backup. Please change based on your server configuration.

Install Sample Database WideWorldImports

USE [master]
RESTORE DATABASE [WideWorldImporters] FROM  
DISK = N'C:\WideWorldImporters-Full\WideWorldImporters-Full.bak' WITH
MOVE N'WWI_Primary' TO N'C:\WideWorldImporters-Full\WideWorldImporters.mdf',  
MOVE N'WWI_UserData' TO N'C:\WideWorldImporters-Full\WideWorldImporters_UserData.ndf',  
MOVE N'WWI_Log' TO N'C:\WideWorldImporters-Full\WideWorldImporters.ldf',  
MOVE N'WWI_InMemory_Data_1' 
TO N'C:\WideWorldImporters-Full\WideWorldImporters_InMemory_Data_1'
GO

Once restore is done, this is what you should see

Do you see a table with clock icon? What is that feature called? These are great ways of learning the new capabilities via the sample database.

Here is a quick SQL in Sixty Seconds video where I explain how we can install sample database.

Reference: Pinal Dave (https://blog.sqlauthority.com)