EOL: SentryOne Test reached its end of life date on June 15, 2022. See the Solarwinds End of Life Policy for more information.
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 VSE, see the Visual Studio Extension Recipes article.
Select Build Recipe from one of the following recipes to open that recipe's configuration page:
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.
2. Select a test framework from the Test Framework drop-down list.
3. Select the remote agent you’d like to use to run the test from the Remote Agent drop-down list.
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.
4. Select a provider from the Select a Provider drop-down list, enter the connection string for your connection, then select Connect to verify the connection.
 |  |
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.
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.
Success: The test assembly is created and available in the Unexecuted Assemblies data testing dashboard.
 Test Assembly Built Successfully
|  Test Assembly in Unexecuted Assemblies
|
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.
2. Select a test framework from the Test Framework drop-down list.
3. Select the remote agent you’d like to use to run the test from the Remote Agent drop-down list.
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, then select Connect to verify the connection.
 |  |
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.
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.
7. Enter a minimum and maximum value for the range check, select any desired informational columns to include in the assembly, then select Build Test to create your Database column range check.
Success: The test assembly is created and available in the Unexecuted Assemblies data testing dashboard.
 |  |
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.
2. Select a test framework from Test Framework the drop-down list.
3. Select the remote agent you’d like to use to run the test from the Remote Agent drop-down list.
4. Select a provider from the Select a Provider drop-down list, enter the connection string for your connection, then select Connect to verify the connection.
 |  |
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.
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.
7. Select any desired grouping columns from the Grouping columns check list, enter a value for the Max Standard Deviation, then select Build Test Assembly to create your Standard Deviation Test.
Success: The test assembly is created and available in the Unexecuted Assemblies data testing dashboard.
 |  |
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.
2. Select a test framework from the Test Framework drop-down list.
3. Select the remote agent you’d like to use to run the test from the Remote Agent drop-down list.
4. Select a provider from the Source Database Provider drop-down list, enter the connection string for the connection, then select Connect to verify the connection.
 |  |
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.
 |  |
6. Select a Source Table, and a Target Table from the drop down lists, then select Add to add the comparison. Repeat this step as many times as desired.
 |  |
7. Select Build Test Assembly to create your row count comparison test.
Success: The test assembly is created and available in the Unexecuted Assemblies data testing dashboard.
 |  |
