- #MICROSOFT ADVENTUREWORKS DATABASE DOWNLOAD HOW TO#
- #MICROSOFT ADVENTUREWORKS DATABASE DOWNLOAD INSTALL#
The line below uses the default location for SQL Server 2005 Express. To attach AdventureWorks to your SQL Serverġ.At the SQLCMD 1> prompt, call the sp_attach_db stored procedure to attach the AdventureWorks database in the data directory determined in the previous step. This query returns the location of the file master.mdf, confirming the SQL Server data directory where you will place the AdventureWorks database files. From the Start menu, click All Programs, Microsoft Visual Studio 2005, Visual Studio Tools, Visual Studio 2005 Command Prompt.Ģ.Open a connection to a local SQL Server Express instance by typing or copying the following command into the command line:Ĥ.At the SQLCMD prompt, type or copy the following commands.Ĭopyselect physical_name from sys.database_files where name = 'master' To confirm your SQL Server data directoryġ.Open a Visual Studio 2005 command window. For SQL Server 2005 Express, the default is c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\. AdventureWorks_Data.mdf and AdventureWorks_Log.ldf are copied to your SQL Server data directory. Double-click AdventureWorksDB.msi.Ģ.Click Run and complete the installation wizard.
#MICROSOFT ADVENTUREWORKS DATABASE DOWNLOAD HOW TO#
The following steps describe how to download, save, attach, and configure the AdventureWorks database.ġ.Navigate to this download Microsoft Web site. If you upgraded an MSDE instance to SQL Server 2005 Express, see the SQL Server Books Online topic "Upgrading MSDE to SQL Server Express". If you installed SQL Server 2005 Express, the default instance name is (local)\sqlexpress. You must have a SQL Server instance installed for which you have permissions. You can view it on MSDN at You can also download the "AdventureWorks OLTP Database Diagram" from. Books Online is available in most editions of Visual Studio 2005. To learn more about using the AdventureWorks sample database, you can search for "AdventureWorks Sample OLTP Database" in SQL Server 2005 Books Online.
#MICROSOFT ADVENTUREWORKS DATABASE DOWNLOAD INSTALL#
If you already have a previous version of AdventureWorks, you should install the most recent version so that the queries in other ReportViewer walkthroughs work as expected. The version of AdventureWorks that is distributed with SQL Server 2005 is different from earlier versions AdventureWorks. You can use the instructions provided in this walkthrough to download, install, and configure a connection to the AdventureWorks database.
AdventureWorks is not automatically installed with SQL Server or SQL Server Express, but can be downloaded from a Microsoft Web site. This walkthrough shows how to install the AdventureWorks sample database for SQL Server 2005, which is a prerequisite for other walkthroughs provided in the ReportViewer documentation. Walkthrough: Installing the AdventureWorks Database Just in case the page disappears, copying here. Just had to use regular SQL database, not sqlexpress, but that was easy to find by refreshing the database list. It was hard to track down a useful reference for installing the AdventureWorks database - this one worked (almost).
0 kommentar(er)
