Prior to upgrading ICA, there are scenarios where the product support team may request that the RiskFabric database schema is exported for further review. This process will walk you through the process of what options need to be included when exporting the schema for product support. We will exclude user information in this export but we will seek index information, triggers and other database dependent Objects.
Launch SSMS and connect to the database server in question.
Right-click on the database you want to script out and select “Generate Scripts….” Option.
Click Next on the Introduction Page.
On the Choose Objects page,
check everything except Users and Database Roles as these are irrelevant to our analysis.
Click the Advanced…. Button
After clicking advanced make sure the following settings are set:
Generate Script for Dependent Objects: True (this is default)
Include system constraint names: True
Script Statistics: Script Statistics
Script USE DATABASE: FALSE
Script Indexes: True (should be true by default) Make sure it is checked
Script Triggers: True
Specify file to save to, Click Next … finish the wizard the schema will be contained in this file.
Subscribing will provide email updates when this Article is updated. Login is required.