- Where can I find the Northwind database for Microsoft SQL Server ? - Stack Overflow

on

Looking for:

Sql server northwind database 2008 download 













































     


Sql server northwind database 2008 download -



  1. First we need to download available · file from this location Northwind and Pubs Sample Database ; 2. Once we download · file right click on. However, it is still used in e.g. Microsoft SQL Server Database Development Training Kit so may still be relevant for users trying to learn. In this article I will explain how to download and install the Microsoft's Northwind and Pubs databases and then attach them to the SQL Server or SQL Server.    

 

- Sql server northwind database 2008 download



   

SQL Server beginners and database development beginners are the audience for whom this article is written. I was searching the documentation and came upon samples making use of the Northwind and the Pubs databases. I am an experienced technical writer, and an astrophysicist. Perhaps it may be the case that Microsoft has already posted new documentation on installing databases into SQL Server Management Studio graphically; however, at the time this article was originally posted back in , at the time I had been unable to locate an equivalent article in the Microsoft documentation; hence, I wrote my own, which has evolved into this article.

So, enjoy this article, for what it's worth. It's also lost on me why SQL Server distributions don't come with these databases provided, since they are used so ubiquitously through documentation, websites, and tutorials. There are probably several good reasons for this. However, I am focused on usability, and not on making things harder than they have to be.

I see this article as illustrating just another way to accomplish a similar objective. It's worth noting, for example, that a default Visual Studio. NET 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. Personally, I favor using graphical GUI tools and methods over typing cryptic commands and deciphering error messages.

So, this article illustrates how to install the Northwind and Pubs databases using graphical tools and methods. Step 1 : Using the download link above, download the Zip file containing the following files. Extract the files to a directory on your computer and remember where you put them.

For these steps to work, you must have the following files on your computer:. Once the installation is completed you can check the installed database files in the following location, and you will find the Northwind Database in the Installation Folder.

In the Context Menu click on the Attach option as shown below. MDF file and press OK button. Related Articles. Add Comments. Thank you for the feedback. The comment is now awaiting moderation. You will be notified via email when the author replies to your comment. Please select a comment to reply. You can add your comment about this article using the form below. Make sure you provide a valid email address else you won't be notified when the author replies to your comment Please note that all comments are moderated and will be deleted if they are Not relavant to the article Spam Advertising campaigns or links to other sites Abusive content.

Please do not post code, scripts or snippets. Required Invalid Email Address. Security code:. Required Invalid security code.



Comments

Post a Comment