Create SQL Server Sample Databases in your SQL Server instance
Create Wide World Importers Data warehouse for SQL Server 2019. Wide World Importers Database is a Microsoft SQL Server 2016 Sample.
/* Wide World Importers DW - Sample Database */
/* 1. Create a Folder with any name in your favourite drive and place the below downloaded sample DW file in that folder */
Example: C:\SQLServerSamples\
/* 2. Create a sub-folder in the above folder with name "Data" */
Example: C:\SQLServerSamples\Data\
/* 3. Download Samples From below Microsoft github link */
https://github.com/Microsoft/sql-serv...
/* 4. Restore the database using below script */
RESTORE DATABASE [WWI_DW]
FROM
DISK = N'C:\SQLServerSamples\WideWorldImportersDW-Full.bak'
WITH
MOVE N'WWI_Primary'
TO N'C:\SQLServerSamples\Data\WWIDW.mdf',
MOVE N'WWI_UserData'
TO N'C:\SQLServerSamples\Data\WWIDW_UserData.ndf',
MOVE N'WWI_Log'
TO N'C:\SQLServerSamples\Data\WWIDW.ldf',
MOVE N'WWIDW_InMemory_Data_1'
TO N'C:\SQLServerSamples\Data\WWIDW_InMemory_Data_1'
GO
On this page of the site you can watch the video online Create SQL Server Sample Databases in your SQL Server instance with a duration of hours minute second in good quality, which was uploaded by the user virtbi projects 01 January 1970, share the link with friends and acquaintances, this video has already been watched 2,593 times on youtube and it was liked by 17 viewers. Enjoy your viewing!
