Download the Sample Database Backup File on the Linux machine

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

01-copy-link-locationv1

Copied link:
https://github.com/Microsoft/sql-server-samples/releases/download/wide-world-importers-v1.0/WideWorldImporters-Full.bak

  • Connect to your Linux machine

03-key-userid-and-password

  • Verify the new sample database backup WideWorldImportersFull.bak file exists on the server or not;

Syntax: ls -l

04verifybackalreadythere

The above output confirms that there is no sample database backup file on the server.

  • Download the sample database backup file

Syntax : wget ‘WWIFullbackupURL’

05-wget

Once the backup file get downloaded successfully, you will see saved message; refer the below image

06-backupdownloaded1

  • Double verify the new sample database backup WideWorldImportersFull.bak file exists on the server or not;

Syntax: ls -l

07-verifythedownloadedbackup

Now, you can see the sample database backup file.

Happy learning!

Leave a comment

Your email address will not be published. Required fields are marked *