🌐
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
This folder contains scripts to create and load the Northwind (instnwnd.sql) and pubs (instpubs.sql) sample databases. These scripts were originally created for SQL Server 2000.
Author   microsoft
🌐
Wikiversity
en.wikiversity.org › wiki › Database_Examples › Northwind › SQL_Server
Database Examples/Northwind/SQL Server - Wikiversity
-- Either: -- Open Microsoft SQL Server Management Studio. -- Connect to your server. -- Open a new query window. -- Copy and paste the SQL below into the query window. -- Execute the script to create the Northwind database. -- Or: -- Run the following command in a terminal window.
Discussions

Import Northwind Sample
Why are you doing it that way instead of just using sql express installation to learn SQL? More on reddit.com
🌐 r/SQLServer
9
3
May 10, 2021
How can I install the Northwind database into SQL Server Local DB? - Stack Overflow
This will list all the instances ... for my example) ... Open management studio and in the server box connect to the named pipe (windows auth) e.g. : ... 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 ... More on stackoverflow.com
🌐 stackoverflow.com
Origin of "Northwind" Database
Microsoft created the Northwind dataset. "Northwind" is the name of a fictional company to which the data supposedly belongs. I have no idea if there is any deeper meaning to it. More on reddit.com
🌐 r/AskProgramming
4
10
March 27, 2022
Northwind database and Normal forms question/help
Address does depend on city but also in a hypothetical address table there could be multiple of the "same" addresses in different cities. There also could be the Cities of the same name in countries (93 Springfields in the US). The unique address then is then probably defined by (address, city, country). Note a customer (that has a home address) can have an order delivered to another address. Important to consider what an address is used for when considering form. More on reddit.com
🌐 r/SQL
1
3
May 18, 2025
🌐
Microsoft Learn
learn.microsoft.com › en-us › dotnet › framework › data › adonet › sql › linq › downloading-sample-databases
Get the sample SQL Server databases for ADO.NET code samples - ADO.NET | Microsoft Learn
A number of examples and walkthroughs in the LINQ to SQL documentation use sample SQL Server databases and SQL Server Express. You can download these products free of charge from Microsoft. Download the script instnwnd.sql from the following GitHub repository to create and load the Northwind sample database for SQL Server:
🌐
Medium
medium.com › @mythilyrm › the-northwind-database-f2fa1f59daa7
The Northwind database
April 22, 2023 - The discount for each item is stored in the discount column of the order_items table. (For example, a 0.20 discount means that the customer pays 1 - 0.2 = 0.8 of the original price.) Add a second column named total_price_after_discount.
🌐
GitHub
raw.githubusercontent.com › microsoft › sql-server-samples › master › samples › databases › northwind-pubs › instnwnd.sql
Northwind database - GitHub
-- 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 strings are interpreted correctly regardless of the default DATEFORMAT on the server.
🌐
Codeontime
codeontime.com › learn › sample-applications › northwind
Code On Time: Sample Applications / Northwind (SQL Server)
Code On Time creates premium database apps straight from your database! A premium line-of-business app handles millions of records and presents data on any device via a universal user interface with responsive design. It displays data in forms, grids, lists, charts, maps, calendars, and spreadsheets.
🌐
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
This folder contains scripts to create and load the Northwind (instnwnd.sql) and pubs (instpubs.sql) sample databases. These scripts were originally created for SQL Server 2000.
Author   microsoft
🌐
Wikiversity
en.wikiversity.org › wiki › Database_Examples › Northwind
Database Examples/Northwind - Wikiversity
March 21, 2025 - Northwind Traders is a database sample that is shipped along with the Microsoft Access application.[1] The Northwind database is available under a Microsoft Public License.[2] Categories · Customers · Employees · OrderDetails · Orders · ...
Find elsewhere
🌐
Alpha Software
documentation.alphasoftware.com › documentation › pages › GettingStarted › GettingStartedTutorials › Basic Tutorials › Northwind › northwindSQLServer.xml
Importing the Northwind Access Database into SQL Server
Open SQL Server Management Studio. Right-click on "Databases" and select New Database... from the context menu. Create a New Database... In the Database name field, type in "northwind" and click OK
🌐
7-Zip Documentation
documentation.help › tsqlref › ts_north_2ch1.htm
Northwind Sample Database - Transact-SQL Reference Documentation
documentation.HELP! Transact-SQL Reference Documentation ... The Northwind Traders sample database contains the sales data for a fictitious company called Northwind Traders, which imports and exports specialty foods from around the world.
🌐
InformIT
informit.com › articles › article.aspx
The SQL Server Sample Databases: NorthWind | SQL Server Reference Guide | InformIT
Starting in SQL Server 2008, Microsoft is no longer including the sample databases on the SQL Server installation media. You have to download them from the “Codeplex” site. In fact, you can get most all of the sample databases there. I’ll include a link to all of that at the end of this article. The Northwind database was Microsoft’s first attempt at making a unified set of objects available for cross-platform examples.
🌐
SQLServerCentral
sqlservercentral.com › home › articles › sql server sample databases
SQL Server Sample Databases – SQLServerCentral
June 27, 2022 - These databases used to be included in the SQL Server 2000 installer. Now, you can find it on GitHub at the following URL: https://github.com/microsoft/sql-server-samples/tree/master/samples/databases/northwind-pubs
🌐
zentut
zentut.com › home › sql tutorial › sql sample database
SQL Sample Database
April 22, 2024 - The Northwind sample database provides you with a good database structure and sales data that help you experiment with SQL statements quickly.
🌐
MSSQLTips
mssqltips.com › home › microsoft sql server sample databases
Microsoft SQL Server Sample Databases
July 21, 2025 - The specific location for the Northwind and Pubs creation scripts: https://github.com/microsoft/sql-server-samples/tree/master/samples/databases/northwind-pubs
🌐
GitHub
github.com › harryho › db-samples
GitHub - harryho/db-samples: Northwind sample database for MySql, PostgresQL etc. · GitHub
# Using Docker docker exec -it mssql-infra /opt/mssql-tools18/bin/sqlcmd -S localhost -U sa -P YourStrong!Passw0rd -d northwind -C # Using local sqlcmd (if installed) sqlcmd -S localhost -U sa -P YourStrong!Passw0rd -d northwind ... # Stop all containers docker-compose down # Stop and remove all data volumes (WARNING: deletes all data) docker-compose down -v · If you prefer to install databases manually without Docker, you can use the SQL scripts directly with your local database installations.
Starred by 185 users
Forked by 135 users
Languages   TSQL 95.9% | Shell 1.8% | PowerShell 1.4% | JavaScript 0.9%
🌐
ASPSnippets
aspsnippets.com › Articles › 3401 › SQL-Server-2019-Download-and-Install-Northwind-Database
SQL Server 2019: Download and Install Northwind Database
NORTHWIND.MDF file and press OK button. That’s it. You will see that the database is now available in your SQL Server along with the other databases.
Published   July 28, 2025
🌐
Medium
medium.com › @esegui › complex-sql-statement-explained-44d856752b55
Complex SQL Statement Explained. The Northwind database is a sample… | by Emmanuel Segui | Medium
March 2, 2023 - The Northwind database is a sample ... scenarios. It consists of various tables that represent entities in a typical business environment, such as customers, orders, products, and suppliers. The example ......
🌐
GitHub
github.com › sealbro › northwind
GitHub - sealbro/northwind: Northwind sample database for MySql, PostgresQL etc. · GitHub
MYSQL_URL=https://raw.githubusercontent.com/sealbro/northwind/master/mysql \ && bash -c "$(curl -fsSL $MYSQL_URL/run.sh)" echo "$(curl -fsSL $MYSQL_URL/northwind.sql)"
Starred by 6 users
Forked by 2 users
Languages   JavaScript 88.0% | Shell 12.0%
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.