A release of SQL Server 2016 was not only loaded with rich features & enhancements, but it also brought a new sample database known as Wide World Importers (WWI). Here is the official announcement link.
As Microsoft has decided to end the era for the SQL Server sample database AdventureWorks, it’s time for us to start exploring the new sample database. Hence, I will be following the new sample database to demonstrate this post. In this posts, we will see how we can download the new SQL Server sample databases on Linux machine directly so that you can play more with SQL Server on Linux.
-
Click on the below link to open the WWI release link
https://github.com/Microsoft/sql-server-samples/releases/tag/wide-world-importers-v1.0
-
Copy the backup location from opened link
-
Connect to your Linux machine
-
Verify the new sample database backup WideWorldImportersFull.bak file exists on the server or not;
Syntax: ls -l
The above output confirms that there is no sample database backup file on the server.
-
Download the sample database backup file
Syntax : wget ‘WWIFullbackupURL’
Once the backup file get downloaded successfully, you will see saved message; refer the below image
-
Double verify the new sample database backup WideWorldImportersFull.bak file exists on the server or not;
Syntax: ls -l
Now, you can see the sample database backup file.
Happy learning!