Information
The topic you requested is included in another documentation set. For convenience, it's displayed below. Choose Switch to see the topic in its original location.

How to: Install Sample Databases 

This topic has been updated for Visual Studio 2005 SP1.

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, then consult the SQL Books Online for information on installing it. If you do not have a copy of SQL Server, then you can access the sample databases by installing SQL Server Express, SQL Server Compact 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, choose Import and Export Settings on the Tools menu. For more information, see Visual Studio Settings.

To install SQL Server 2005 Compact Edition

  1. Open Internet Explorer.

  2. Go to the Microsoft Download Center Web site.

  3. In the keywords box, type SQL Server Compact Edition.

  4. Click Go.

  5. On the results page, click the link for the SQL Server Compact Edition Runtime download page, and then follow the instructions to download the SQL Server Compact Edition Runtime.

You also need to download an additional set of tools to work with SQL Server Compact Edition databases in Visual Studio SP1. This set of tools provides the design-time dialog boxes, and new features such as ClickOnce support. The following steps show how to install these additional tools:

  1. Return to the Microsoft Download Center Web site.

  2. In the keywords box, type SQL Server Compact Edition Tools for Visual Studio 2005.

  3. Click Go.

  4. On the results page, click the link for the SQL Server Compact Edition Tools for Visual Studio download page, and then follow the instructions.

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, choose Save This File Now and click OK.

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

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, choose Save This File Now and click OK.

  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, choose Save This File Now and click OK.

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

To download and install SQL Server Express

  1. Open 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, follow the link to the SQL Server Express download page and follow the instructions.

Security

Always check for product updates when installing additional software.

See Also

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

Show:
© 2014 Microsoft