SQL DBA Script Pairing

Each execution script has an equivalent cleanup script for use in circumstances where you wish to undo the changes executed by the execution script. These two scripts must be paired in the dbo.SBCScriptTemplate table.

➢

To pair SQL DBA scripts:

1.

Open the SQL database Object Explorer.

2.

Select SysAdminTenant database.

3.

Expand the Tables folder.

4.

Select the dbo.SBCScriptTemplate table, right-click and select Edit Top 200 Rows.

The template scenario scripts are displayed.

5.

In the dbo.SBCScriptTemplate table, note the scripts that you wish to pair.

6.

Right-click the dbo.SbcScriptRelations table.

7.

Choose Edit Top 200 Rows.

8.

Create a new row and enter the matching Ids for the corresponding Onboarding and Cleanup scripts.

9.

To disable SBC validation, open the dbo.ApplicationSettings table and set SkipSBCValidation to True.

When disabled, the Onboarding script does not check for IP Groups configured on the SBC.