Download backup of Northwind database for SQL Server

By FoxLearn 11/15/2024 9:19:41 AM   70
To get the Northwind sample database for SQL Server, you can follow one of the steps below.

Download Northwind database SQL Server

You can download the instnwnd.sql script from the provided GitHub repository to create and load the Northwind sample database for SQL Server.

This folder contains scripts to create and load the Northwind and Pubs sample databases.

Northwind backup: instnwnd.sql

Sample backup: instpubs.sql

Before using the Northwind database, you must run the downloaded instnwnd.sql script to recreate the database on an instance of SQL Server. This can be done using SQL Server Management Studio (SSMS) or a similar tool.

Download SQL Server Management Studio (SSMS)

Run the scripts in SSMS

Open SSMS and connect to your SQL Server instance.

Create a new database with name Northwind

Next, In the "File" menu, select Open -> File... and choose the instnwnd.sql script you downloaded.

northwind database

Click Execute button to run the script and create the Northwind database on your SQL Server.

Run the scripts in SSDT or Visual Studio

Open SSDT or Visual Studio, then Open the SQL Server Object Explorer.

Next, Connect to the target SQL Server, then open the script in a new query window.

Finally, Run the sql script.