1c. Install the Sample Database

Applies to ReadyAPI 3.10, last modified on October 07, 2021

When working with this tutorial, you will use the AdventureWorks database as the sample data.

Sample data

The AdventureWorks sample database will not be available after the setup if you are using MS SQL Express. You need to download the database separately and install it.

To learn more about the AdventureWorks database, see Microsoft TechNet.

Download the AdventureWorks database

The AdventureWorks Database is a database backup for the MS SQL server.

Download the AdventureWorks2014.bak database backup from GitHub:

https://github.com/Microsoft/sql-server-samples/releases/tag/adventureworks

You can also try the direct download link.

The version of the database backup must be the same as the version of your Microsoft SQL Server installation. In this tutorial, Microsoft SQL Server 2014 is used. If you use a different version, download the corresponding database backup.
You need to save the .bak file to a folder accessible to the NETWORK_SERVICES user.

Restore the database from backup

To install the database backup:

  1. Start the SQL Server Management Studio.

    SQL Server Management Studio: Splash screen
  2. The Connect to Server dialog will appear.

    SQL Server Management Studio: Connect to Server dialog

    Select your named server, use the Authentication method of your choice and click Connect.

  3. The manager connects to the database.

    SQL Server Management Studio: Connected to the database

    Click the image to enlarge it.

    Right-click Databases and select Restore Database.

    SQL Server Management Studio: Calling the context menu

    Click the image to enlarge it.

  4. The Restore Database window will appear.

    Select Device and click Browse:

    SQL Server Management Studio: Selecting a device as a database source

    Click the image to enlarge it.

  5. The Specify Backup dialog appears. Click Add.

    SQL Server Management Studio: Specify Backup dialog

    Click the image to enlarge it.

  6. The Locate Backup File dialog appears.

    Select the directory where you saved the file, select the .bak file and click OK.

    SQL Server Management Studio: Locate Backup File dialog

    Click the image to enlarge it.

  7. The backup will appear on the list. Click OK.

    SQL Server Management Studio: Select backup devices dialog

    Click the image to enlarge it.

  8. The backup also appears in the Restore Database dialog, in the Backup Sets To Restore list.

    SQL Server Management Studio: Restore Database dialog with a backup in the list

    Click the image to enlarge it.

    Make sure to select the Restore check box next to the database backup and click OK.

  9. The database is installed, and a confirmation dialog appears.

    SQL Server Management Studio: Restoration in progress

    Click the image to enlarge it.

    SQL Server Management Studio: Restoration finished

    Click OK.

You have added the database.

SQL Server Management Studio: Database added

Click the image to enlarge it.

Now, you can install the JDBC driver.

Prev          Next

See Also

Microsoft SQL Databases as Data Sources

Highlight search results