Export (0) Print
Expand All

How to: Install Sample Databases

Many Visual Studio topics and code samples require the ability to connect to a database, such as the Northwind sample database. If you are running SQL Server and the Northwind database is unavailable, see the SQL Server Books Online for information about installing it. If you do not have a copy of SQL Server, you can access the sample databases by installing SQL Server Compact 3.5, SQL Server Express Edition, or an Access version of Northwind.

NoteNote:

The dialog boxes and menu commands you see might differ from those described in Help depending on your active settings or edition. To change your settings, click Import and Export Settings on the Tools menu. For more information, see Visual Studio Settings.

To install the Northwind and Pubs sample databases for SQL Server

  1. Open Internet Explorer.

  2. Go to the Northwind and Pubs Sample Databases Web site.

  3. Click Download.

  4. In the File Download box, select Save.

  5. After the file has downloaded, double-click the Nwind.exe file to install the database.

To install the Adventure Works sample databases for SQL Server 2000

  1. Open Internet Explorer.

  2. Go to the Adventure Works Cycles Database 2000 Web site.

  3. Click Download.

  4. In the File Download box, select Save.

  5. After the file has downloaded, double-click the Nwind.exe file to install the database.

To install the Northwind sample database for Microsoft Access

  1. Open Internet Explorer.

  2. Go to the Access 2000 Tutorial: Northwind Traders Sample Database Web site.

  3. Click Download.

  4. In the File Download box, select Save.

  5. After the file has downloaded, double-click the Nwind.exe file to install the database.

SQL Server Express Edition is available for free, and you can redistribute it with applications.

NoteNote:

SQL Server Express Edition is required for Visual Basic 2008 Express Edition and Visual C# 2008 Express Edition users who use the Object Relational Designer (O/R Designer).

To download and install SQL Server Express Edition

  1. Start Internet Explorer.

  2. Go to the Microsoft Download Center Web site.

  3. In the keywords box, type SQL Server Express.

  4. Click Go.

  5. On the results page, click the link to the Microsoft SQL Server 2005 Express Edition download page.

  6. Follow the installation instructions on the Web site.

Always check for product updates when installing additional software.

Community Additions

ADD
Show:
© 2014 Microsoft