Export the RiskFabric relational database schema

Products

• Information Centric Analytics

Issue/Introduction

Under certain circumstances, engineering may request an export of the RiskFabric relational database schema for review prior to performing an upgrade. The procedure documented in this article will generate a script file that include indexes, triggers, and other database-dependent objects, but will exclude confidential data.

Environment

Version : 6.x

Component : Database

Resolution

1. Open SQL Server Management Studio (SSMS)
2. Connect to the Database Engine hosting the RiskFabric relational database
3. In Object Explorer, navigate to Databases > RiskFabric
4. Right-click the RiskFabric database and select Tasks > Generate Scripts
   The Generate Scripts window opens
5. On the Introduction page, click the Next button
6. On the Choose Objects page, select all options except Users and Database Roles (if listed)
7. Click the Next button
8. On the Set Scripting Options page, click the Advanced button
   The Advanced Scripting Options window opens
9. Ensure the following options are configured:
   • Generate Script for Dependent Objects = True
   • Include system constraint names = True
   • Script Statistics = Script Statistics
   • Script USE DATABASE = False
   • Script Indexes = True
   • Script Triggers = True
10. Click the OK button to close the Advanced Scripting Options window
11. Select the radio button to Save as script file and configure the following settings:
    • Files to generate: Single script file
    • Save as: Unicode text
12. Click the Next button
13. Review your selections and click the Next button if no changes are needed
    This will initiate the script generation process
14. Once the process completes, click the Finish button to close the Generate Scripts window