SentryOne Test Web Portal Recipes


SentryOne Test Recipes page

Create tests quickly and easily with the Recipes page on the SentryOne Test Web Portal. Recipes are pre-defined templates that make creating tests without Visual Studio a simple task. The following recipes are templates for common test case scenarios that enable you to build tests without using the Visual Studio environment. 

Note:  The Recipes available on the SentryOne Test Web Portal are also available in the Visual Studio Extension. For more information about the Recipes in the Visual Studio Extension, see the VS Extension Recipes article. 

Select Build Recipe from one of the following recipes to open that Recipe's configuration page :

Uniqueness Check

Database column uniqueness check

The Database column uniqueness check verifies the uniqueness of a column or set of columns in a database table. 

Create a Database column uniqueness check test by completing the following steps on the Recipe's configuration page: 

1. Enter a meaningful name for your test.

SentryOne Test Database column uniqueness check enter test name

2. Select a test framework from the  Test Framework drop-down list. 

SentryOne Test Datbase column uniqueness check Test Framework

3. Select the remote agent you’d like to use to run the test from the Remote Agent drop-down list.

SentryOne Test Database column uniqueness check select Remote Agent

Note:  Selecting a remote agent opens the Retrieving list of database providers... pop up window, which verifies that a connection can be made. A successful connection makes the Select a Provider drop-list available for selection.

SentryOne Test Retrieving list of database providers

4. Select a provider from the Select a Provider drop-down list, enter the connection string for your connection, and then select Connect to verify the connection. 

SentryOne Test Database column uniqueness check select a provider
SentryOne Test Database column uniqueness check Connection String

Note:  Selecting Connect opens the Retrieving a list of database providers... pop up window, which verifies that a connection can be made. A successful connection makes the Table drop-down box available for selection.

5. Select a table from the Table drop-down list. 

SentryOne Test Database column uniqueness check select Table

Note:  Selecting a table opens the Retrieving list of database providers... pop up window , which verifies that a connection can be made. A successful connection displays a list of columns from the selected table.

6. Select the desired columns from the Column(s) list, and then select Build Test Assembly to create your Database column uniqueness check. 

SentryOne Test Database column uniqueness check Build Test Assembly

Success: The test assembly is created and available in the Unexecuted Assemblies Data Testing Dashboard.

SentryOne Test Recipe built successfully
Test Assembly Built Successfully

SentryOne Test Database column uniqueness check test in Unexecuted Assemblies
Test Assembly in Unexecuted Assemblies
Range Check

Database column range check

The Database column range check verifies the values within a specific database table column are within a defined range.

Create a Database column range check test by completing the following steps on the Recipe's configuration page: 

1. Enter a meaningful name for your test.

SentryOne Test Database column range check enter a test name

2. Select a test framework from the Test Framework drop-down list.

SentryOne Test Database column range check select Test Framework

3. Select the remote agent you’d like to use to run the test from the Remote Agent drop-down list.

SentryOne Test Database column range check select Remote Agent

Note:  Selecting a remote agent opens the Retrieving list of database providers... pop up window, which verifies that a connection can be made. A successful connection makes the Select a Provider drop-down list available for selection.

4.  Select a provider from the Select a Provider  drop-down list, enter the connection string for your connection, and then select Connect to verify the connection.


SentryOne Test Database column range check Select a provider


SentryOne Test Database column range check enter connection string and Connect

Note:  Selecting Connect opens the Retrieving a list of database providers... pop up window, which verifies that a connection can be made. A successful connection makes the Table drop-down list available for selection.

5. Select a table from the Table drop-down list.

SentryOne Test Database column range check select Table

Note:  Selecting a table opens the Retrieving list of database providers... pop up window , which verifies that a connection can be made. A successful connection makes the Column(s) drop-down list available for selection.

6. Select a column from the Column(s) drop-down list.

SentryOne Test Datbase column range check select Column

7. Enter a minimum and maximum value for the Range check, select any desired informational columns to include in the assembly, and then select Build Test to create your Database column range check. 

SentryOne Test Database column range check Build Test Assembly

Success: The test assembly is created and available in the Unexecuted Assemblies Data Testing Dashboard.

SentryOne Test Database column range check Test Assembly Built Successfully
SentryOne Test Database column range check in Unexecuted Assemblies
Standard Deviation

Database column standard deviation

The Database column Standard deviation verifies the standard deviation of values within a database table column. 

Create a Database column standard deviation test by completing the following steps on the Recipe's configuration page:

1. Enter a meaningful name for your test.

SentryOne Test Database column standard deviation enter Name

2. Select a test framework from Test Framework the drop-down list.

SentryOne Test Database column standard deviation select Test Framework

3. Select the remote agent you’d like to use to run the test from the Remote Agent drop-down list. 

SentryOne Test Database column standard deviation Select Remote Agent

4. Select a provider from the Select a Provider drop-down list, enter the connection string for your connection, and then select Connect to verify the connection.

SentryOne Test Database column standard deviation Select Provider
SentryOne Test Database column standard deviation Connection String and connect

Note:  Selecting Connect opens the Retrieving a list of database providers... pop up window, which verifies that a connection can be made. A successful connection makes the Table drop-down list available for selection.

5. Select a table from the Table drop-down list.

SentryOne Test Database column standard deviation select Table

Note:  Selecting a table opens the Retrieving list of database providers... pop up window , which verifies that a connection can be made. A successful connection makes the Standard Deviation Column drop-down list available for selection.

6. Select a column from the Standard Deviation Column drop-down list.

SentryOne Test Databse column standard deviation select Standard Deviaton column

7. Select any desired grouping columns from the Grouping columns check list, enter a value for the Max Standard Deviation, and then select Build Test Assembly to create your Standard Deviation Test.

SentryOne Test Database column standard deviation Build Test Assembly

Success: The test assembly is created and available in the Unexecuted Assemblies Data Testing Dashboard.

SentryOne Test Database column standard deviation test assembly built successfully
SentryOne Test Database column standard deviation test in Unexecuted Assemblies
Count Comparison

Database table row count comparison

The Database table row count comparison verifies the row counts between database tables. 

Create a Database table row count comparison test by completing the following steps on the Recipe's configuration page:

1. Enter a meaningful name for your test.

SentryOne Test Database table row count comparison enter Name

2. Select a test framework from the Test Framework drop-down list.

SentryOne Test Database table row count comparison select Test Framework

3. Select the remote agent you’d like to use to run the test from the Remote Agent drop-down list. 

SentryOne Test Database table row count comparison select Remote Agent

4. Select a provider from the Source Database Provider drop-down list, enter the connection string for the connection, and then select Connect to verify the connection. 

SentryOne Test Database table row count comparison select Source Database Provider
SentryOne Test Database table row count comparison Source Connection String

Note:  Selecting Connect opens the Retrieving a list of database providers... pop up window, which verifies that a connection can be made. A successful connection makes the Use Source Provider and Connection for Target checkbox, and Source Tables drop-down box available for selection.  

5. Repeat step four for the Target Database Provider if you wish to connect a different source connection for the comparison, or select Use Source Provider and Connection for Target to use the same connection. 

SentryOne Test Database table row count comparison Target Connection String
SentryOne Test Database table row count comparison Use Source Provider and Connection for Target

6. Select a Source Table, and a Target Table from the drop down lists, and then select Add to add the comparison. Repeat this step as many times as desired.

SentryOne Test Database table row count comparison select Source Table and Target Table
SentryOne Test Database table row count comparison Add Comparison

7. Select Build Test Assembly to create your row count comparison test. 

SentryOne Test Database table row count comparison Build Test Assembly

Success: The test assembly is created and available in the Unexecuted Assemblies Data Testing Dashboard.

SentryOne Test Database table row count comparison Test Assembly Built Successfully
SentryOne Test Database table row count comparison test in Unexecuted Assemblies