3 SQL Version of NorthWind Database

Submitted by: 
Language: 
Visitors have accessed this post 660 times.

A great way to learn database programming is to have a good sample database with lots of tables and appropriate relationships between them to work with. Queries can then be composed from within a variety of programming platforms, such as Java, PHP, Visual Basic 6, Visual Basic.Net, Visual C#, etc.

NorthWind is a free sample database that Microsoft included with every version of Access going all the way back to Access '97 -- 21 years ago to help people get started with the Access program.

The zip file contains 3 versions of the database for use in the following programs:
1. Access 2003.
2. MySQL server
3. Microsoft SQL Server 2008 R2 (and perhaps compatible with later versions of the server).

To install the database in Microsoft SQL Server you must have MS SQL server already installed and Server Management Studio (the graphical database editor program). Then just log into the server. Then select File ->Open -> File. Then navigate to the sql script file named: instnwnd.sql. Then execute the script from within Server Management Studio.

To install Northwind on MySQL server you must already have MySql server installed and running. You should also have MySQL Workbench (the graphical database editor program) installed. Then from within Workbench load and run these two scripts:
northwind.sql and northwind-data.sql.

The screen shot shows NorthWind running on Microsoft SQL Server 2008 R2.


Note: Due to the size or complexity of this submission, the author has submitted it as a .zip file to shorten your download time. After downloading it, you will need a program like Winzip to decompress it.

Virus note: All files are scanned once-a-day by SourceCodester.com for viruses, but new viruses come out every day, so no prevention program can catch 100% of them.

FOR YOUR OWN SAFETY, PLEASE:

1. Re-scan downloaded files using your personal virus checker before using it.
2. NEVER, EVER run compiled files (.exe's, .ocx's, .dll's etc.)--only run source code.

Add new comment

Filtered HTML

  • Web page addresses and e-mail addresses turn into links automatically.
  • You may insert videos with [video:URL]
  • Allowed HTML tags: <a> <em> <strong> <cite> <blockquote> <code> <ul> <ol> <li> <dl> <dt> <dd> <table> <tr> <td> <th> <img> <h1> <h2> <h3> <iframe> [video]
  • You can enable syntax highlighting of source code with the following tags: <code>, <blockcode>, <asp>, <c>, <cpp>, <csharp>, <css>, <html4strict>, <java>, <javascript>, <mysql>, <php>, <python>, <sql>, <vb>, <vbnet>. The supported tag styles are: <foo>, [foo].
  • Lines and paragraphs break automatically.

Plain text

  • No HTML tags allowed.
  • Lines and paragraphs break automatically.
CAPTCHA
This question is for testing whether or not you are a human visitor and to prevent automated spam submissions.