Downgrade Touchstone exposure database

Improvements to accelerate downgrade of the Touchstone exposure database.

This release includes the ability to downgrade the Touchstone exposure database using the public API service.

Downgrade the current version to a previous version of the Touchstone exposure database

The new SubmitDowngradeDatabases method enables you to indicate which attached and eligible current exposure database(s) you want to downgrade to the prior version. The SubmitDowngradeDatabasesRequest class stores a list of available databases that you want to downgrade. You can configure the downgrade job such as the name and file path where you want to store the downgraded version of the Touchstone exposure database.
Table 1. Updated AIR.Services.DataSourceManagement.API namespace
Property Type Description
DowngradeDatabasesInfo List<AIR.Services.DataSourceManagement.Data.DowngradeDatabaseInfo> DowngradeDatabasesInfo (Required) Contains a list of current version exposure databases and information about the target databases they will be downgraded to.

The SubmitDowngradeDatabasesResponse class returns the Activity SID associated with your request.

The downgrade works only on databases with the same SQL Server version. If the original and target download databases are not using the same SQL Server version, contact Verisk Technical Support for assistance. The exposure databases which are older than the current Touchstone environment version is not eligible for downgrade.

Note: You cannot use the public API service to downgrade the Touchstone Result database.