Pubs and Northwind: Classic Sample Databases for SQL Server - Download and Explore
Before you can use the Northwind database, you have to run the downloaded instnwnd.sql script file to recreate the database on an instance of SQL Server by using SQL Server Management Studio or a similar tool. Follow the instructions in the Readme file in the repository.
download pubs and northwind database
However, hats off to Microsoft for putting apples with apples. Microsoft provides the queries for installing, but not the *.mdf and *.ldf files for the databases themselves. This does not support users in installing these important samples into SQL Server. Perhaps there's an easier way: this article. The download attached to this article contains the SQL Server 2000 versions of these files.
It's worth noting, for example, that a default Visual Studio .NET 2008 Professional Edition installation does not distribute these databases. Unlike the previous version of Visual Studio .NET, it does not even go part-way by installing the required SQL Scripts --- at least, I have not been able to locate them with the latest version. The download attached to this article contains the latest version of the Northwind and Pubs database files as distributed by Microsoft on MSDN.
i am trying to work in sql server 2005, i want some sample data base other than the tarditional northwind and puds database. And also some please give me some ebooks so that i can learn the SQL querys very fast..
Having trouble attaching northwind database to your SQL Server 2012? Well you are not alone! Northwind is the name of the sample database for SQL Server 2000, that later got replaced with the AdventureWorks sample database in SQL Server 2005. However, it is still used in e.g. Microsoft SQL Server 2008 Database Development Training Kit so may still be relevant for users trying to learn SQL essentials.
The MySQL's Sample Salika (DVD Rental) Database can be downloaded from It is a complex database with 16 tables. It also illustrates features such as Views, Stored Procedures and Triggers. This is probably the best sample available for studying MySQL databases.
For MS SQL Server, you can download the Northwind database from "Northwind and Pubs Sample Databases for SQL Server 2000". Run the downloaded ".msi" file, it will extract the files into "C:\SQL Server 2000 Sample Databases". The SQL statements are kept in "instnwnd.sql".
Download Northwind related Access Database Programs and Templates for Microsoft Access 2007, 2010, 2013 or 2016 Software. Northwind Access database, northwind Microsoft Access templates and examples of northwind for MS Access. These MS Access database templates can be used for small business, non profit organization, student or personal use.