Menu
To install the AdventureWorks database, navigate to the codeplex (http://msftdbprodsamples.codeplex.com/) site and download the MSI for the version of SQL Server you are using. This tutorial expects that the reader is using SQL Server 2008 R2, and all the exercises will be using this version of SQL Server.
Northwind doesn't come installed with SQL Server 2008. You can instead:
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.
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
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.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With