Install Microsoft Northwind and Pubs sample database in SQL Server Management Studio

In this article we discuss how to install Microsoft Northwind and Pubs Sample database in SQL Server Management Studio.

➤What is Northwind database

The Northwind database is a sample database used by Microsoft to demonstrate the features of some of its products, including SQL Server and Microsoft Access. The database contains the sales data for Northwind Traders, a fictitious specialty foods exportimport company.

➥ How to Download the Microsoft’s free sample Northwind database

To download Northwind database please follow the below coreprogramm Github link. You can find there a msi extension file.

</> Northwind Database Github.com/CoreProgramm/

Fig-1.1

➥ Installing Microsoft’s free sample Northwind database

To install the database first download the msi package through Github then open the msi file then follow the on screen setup.

Once the installation is completed you can check the installed database files in the following location, "C:\SQL Server 2000 Sample Databases"

Fig-1.2

➥ Attach the Northwind MDF file to SQL Server using SSMS following below steps

Fig-2

After clicking OK button the database is attached like below;

Fig-3

Like this you can attach Pubs database.

  Summary

In this tutorial we discussed Install Microsoft Northwind and Pubs sample database in SQL Server Management Studio. If have any question related to this topic then give your feedback.