Where can I find the Northwind database for Microsoft SQL Server 2008?

Question

I'm trying to find and create/import the Northwind database to practice my Linq-fu.

I cannot find it for the life of me, searching just turns me to this page, which in turn tells me to find it on the official page which isn't there.

http://msdn.microsoft.com/en-us/library/ms227484%28v=vs.90%29.aspx

Where can I find the Northwind database?

Answer 1

Northwind doesn't come installed with SQL Server 2008. You can instead:

• download scripts for creating the Northwind and pubs sample databases.
• download Northwind and pubs MDF/LDF from Microsoft. The article is titled "SQL Server 2000 Sample Databases".

They come in SQL Server 2000 format / compatibility mode. Microsoft seems to have stopped using these 2 in favour of the new sample database for SQL Server 2008: AdventureWorks.

You can download AdventureWorks 2008 R2 SR1.

Microsoft has its SQL Server Product Database samples at CodePlex.

Answer 2

Try this for a step by step tutorial on how to find the download and install the Northwind and Pubs databases for Sql Server 2008.

northwind database sql server 2008

Answer 3

For any edition of SQL SERVER. You can create the database yourself using Northwind database creation script.

Download Northwind.sql.zip from this site https://northwinddatabase.codeplex.com/downloads/get/269239

then create a database called Northwind in your Sql Server then. Unzip / decompress the file then open the sql file in Sql Server Management Studio select all code (ctrl+a) then press execute.