Previous Next  

  Download AdventureWorks

In this training we will be using the sample transactional database known as "AdventureWorks 2014". This database is provided by Microsoft and is free to download.

Instructions for downloading and mounting the AdventureWorks Dataset:

  1. Follow the link: Microsoft AdventureWorks Sample Databases on CodePlex.
  2. Select the "Download AdventureWorks Databases - 2014" link to begin the download.
  3. Unzip the database (mdf) file and log (ldf) file in a known location.
  4. Open Microsoft SQL Server Management Studio, The "Connect to Server" dialog will open. Click Connect.
  1. Right click Databases.
  2. Click Attach.
  1. Click the Add button.
  2. Locate the AdventureWorks database mdf file (AdventureWorks2014_Data.mdf) where you unzipped it.
  3. Click the OK button on the Locate Database Files dialog window.
  4. Click the OK button on the Attach Databases dialog window to attach the database.

More info on attaching databases in SQL Server: https://docs.microsoft.com/en-us/sql/relational-da...

0 comments