🌐
ASPSnippets
aspsnippets.com › Articles › 3401 › SQL-Server-2019-Download-and-Install-Northwind-Database
SQL Server 2019: Download and Install Northwind Database
In this article I will explain with an example, how to download and install the Northwind database in SQL Server 2019.
Published   July 28, 2025
🌐
GitHub
github.com › microsoft › sql-server-samples › tree › master › samples › databases › northwind-pubs
sql-server-samples/samples/databases/northwind-pubs at master · microsoft/sql-server-samples
To run this sample, you need a tool that can run Transact-SQL scripts. You can run the scripts in the following tools: SQL Server Management Studio (SSMS). To download SSMS, go to Download SQL Server Management Studio (SSMS).
Author   microsoft
🌐
YouTube
youtube.com › watch
SQL Server - How to Download and Restore the Northwind database | FoxLearn - YouTube
Download and Restore the Northwind database to SQL Server 2012/2014/2016/2017/2019. You can use the Northwind database to play the demoWebsite: https://foxle...
Published   September 25, 2018
🌐
FoxLearn
foxlearn.com › home › sql › how to download and restore northwind database to sql server
How to Download and Restore Northwind database to SQL Server
February 28, 2025 - The Northwind database can be downloaded either as an executable SQL script or as a backup file (.bak) for easy restoration. It includes sample data and is compatible with SQL Server 2005, 2008, 2012, 2014, 2016, 2017, 2019, and 2024.
🌐
GitHub
raw.githubusercontent.com › microsoft › sql-server-samples › master › samples › databases › northwind-pubs › instnwnd.sql
Northwind database - GitHub
/* ** Copyright Microsoft, Inc. 1994 - 2000 ** All Rights Reserved. */ -- This script does not create a database. -- Run this script in the database you want the objects to be created. -- Default schema is dbo. SET NOCOUNT ON GO set quoted_identifier on GO /* Set DATEFORMAT so that the date ...
🌐
GitHub
gist.github.com › jmalarcon › e98d20735d17b3160766c041060d1902
Northwind Reborn - Base de datos de ejemplo de SQL Server · GitHub
Descarga el ZIP que tienes en este enlace. y descomprímelo en cualquier carpeta de tu equipo. Dentro hay un archivo llamado northwind.sql.
🌐
GitHub
github.com › microsoft › sql-server-samples › blob › master › samples › databases › northwind-pubs › readme.md
sql-server-samples/samples/databases/northwind-pubs/readme.md at master · microsoft/sql-server-samples
To run this sample, you need a tool that can run Transact-SQL scripts. You can run the scripts in the following tools: SQL Server Management Studio (SSMS). To download SSMS, go to Download SQL Server Management Studio (SSMS).
Author   microsoft
🌐
SQLServerCentral
sqlservercentral.com › home › articles › sql server sample databases
SQL Server Sample Databases – SQLServerCentral
June 27, 2022 - We have the Instwnd.sql file which is the northwind installer. The instpubs.sql will install the pub's database. First, click on the file and press download.
Find elsewhere
🌐
GitHub
github.com › yugabyte › yugabyte-db › wiki › Northwind-Sample-Database
Northwind Sample Database
July 22, 2019 - The latest instructions on how to get up and running are on our Quickstart page here: ... You can download the Northwind database that is compatible with YugaByte DB from our GitHub repo.
Author   yugabyte
🌐
Sololearn
sololearn.com › en › Discuss › 1755569 › hi-guys-how-do-i-download-the-northwind-database-for-sql-workbench-the-northwind-database-i-have-is-for-sql-server
Hi guys, how do I download the Northwind database for ...
Sololearn is the world's largest community of people learning to code. With over 25 programming courses, choose from thousands of topics to learn how to code, brush up your programming knowledge, upskill your technical ability, or stay informed about the latest trends.
🌐
YouTube
youtube.com › watch
- YouTube
Enjoy the videos and music you love, upload original content, and share it all with friends, family, and the world on YouTube.
Top answer
1 of 2
12

So, I can't seem to find a way of attaching an existing DB file to a LocalDB instance from inside visual studio (creating a new DB seems to be the only option), but you can do it via management studio by doing the following:

Step 1 - Find out the instance name of the LocalDB

Open a command prompt and run (the location may be slightly different depending on your install location):

C:\Program Files\Microsoft SQL Server\110\Tools\Binn>SqlLocalDB.exe info

This will list all the instances of LocalDB, find the one you're interested in, VS2012 installed one for me called v11.0 (which I will use for my example)

Step 2 - Start the LocalDB instance

Again in your command prompt run the following:

C:\Program Files\Microsoft SQL Server\110\Tools\Binn>SqlLocalDB.exe start v11.0

This will start the LocalDB instance and allow us to get the connection info

Step 3 - Get the name of the named pipe to connect to (pipe name changes every restart)

Another command prompt job:

C:\Program Files\Microsoft SQL Server\110\Tools\Binn>SqlLocalDB.exe info v11.0

This will then return information about the instance, including the following line:

Instance pipe name: np:\.\pipe\LOCALDB#A6F550C6\tsql\query

Step 4 - Connect via management studio and attach the database

Open management studio and in the server box connect to the named pipe (windows auth) e.g. :

\.\pipe\LOCALDB#A6F550C6\tsql\query

You will now be in the SQL server like it was a normal instance, you can copy your Northwind MDF file to the data directory of the instance (mine was the root of my user folder) and then in the databases node in the management studio right click and select attach, select the MDF file and then attach as normal.

Hope this helps.

2 of 2
1

How about just restoring via SSMS using Steps:

  1. Download northwind (https://northwinddatabase.codeplex.com/) and save .bak somewhere
  2. Open SSMS
  3. Connect to (localdb)\ProjectsV12 (or whatever version you have)
  4. Right Click Databases Node (see image)
  5. Select Restore...

  1. In Restore Database window, Source | choose 'Device' radio button and in drop down 'Backup media Type' choose File and then click 'Add' button browse to location of downloaded .bak file

  1. That's it, your .bak should be loaded to a new database on your machine.
🌐
GitHub
github.com › microsoft › sql-server-samples › blob › master › samples › databases › northwind-pubs › instpubs.sql
sql-server-samples/samples/databases/northwind-pubs/instpubs.sql at master · microsoft/sql-server-samples
Azure Data SQL Samples - Official Microsoft GitHub Repository containing code samples for SQL Server, Azure SQL, Azure Synapse, and Azure SQL Edge - sql-server-samples/samples/databases/northwind-pubs/instpubs.sql at master · microsoft/sql-server-samples
Author   microsoft
🌐
Alpha Software
documentation.alphasoftware.com › documentation › pages › GettingStarted › GettingStartedTutorials › Basic Tutorials › Northwind › northwindSQLServer.xml
Importing the Northwind Access Database into SQL Server
The Northwind Access database can be found inside the MDBFiles directory in your Alpha Anywhere installation. Your Alpha Anywhere install is typically located at C:\Program Files (x86)\a5v12. In this tutorial, you will learn how to convert the Northwind Access database to a SQL Server database.
🌐
Google Code
code.google.com › archive › p › northwindextended › downloads
Google Code Archive - Long-term storage for Google Code Project Hosting.
Archive · Skip to content · The Google Code Archive requires JavaScript to be enabled in your browser · Google · About Google · Privacy · Terms
🌐
Reddit
reddit.com › r/sql › want to download northwinds sample database, but confused
r/SQL on Reddit: Want to download Northwinds sample database, but confused
June 2, 2022 -

I get better at SQL (I am pretty new to it), I heard you could download the MS Northwinds sample database to practice on. I went to this URl: sql-server-samples/samples/databases/northwind-pubs at master · microsoft/sql-server-samples · GitHub

but all I see are 2 fix files, an Azure SQL database, and a readme. I already have SQL Management studio installed, but not sure how to download this and attach it