Database Export Tool

Use the Export Data option in CSM Administrator to export a selected CSM database to a compressed Cherwell Archive Repository (.czar) file.

You can export:

• A single Business Object.
• An entire system (full backup).
• A log file to capture the details of the database export.

To export a single Business Object:

1. In CSM Administrator, select the Database category, and then select the Export data task.

   The Export Data window opens.

2. Select the Export Single Business Object option.

   The window changes to select a single Business Object.

3. Select the Business Object to export.
4. Select the Exclude encrypted fields and protected stored values check box to exclude encrypted fields from the export. We recommend excluding encrypted fields and protected stored values you will provide the data to the CSM support team.
5. (Optional) Select the Logging check box to generate and export a log file (.log) that captures the details of the export. This file is named the same and exported to the same location as the .czar file.
6. In the Save To field, provide a name for the .czar file (example: Incident_Nov2014), and then specify a location. Provide a location or select the ellipsis to navigate to a location.

7. Select OK.

To export a system:

1. Follow step 1 above.
2. Select the Export Entire System check box.
3. Select the content to export:
   • Export All Data: Exports all SQL Server tables (example: Field names and sizes) and data. Use this option to create a full backup .czar of an entire CSM system, and then select to exclude the following so the file is smaller:
     • Exclude Attachments: Exports the Attachment table but not the attachment data within the table. Use this option to create a .czar file to troubleshoot problems that are not related to file attachments.
     • Exclude automation data: Exports the Events and Scheduler tables, but not the data within the tables. Use this option to create a .czar file to troubleshoot problems that are not related to Automation Processes or scheduled items.
     • Exclude encrypted fields and protected stored values: Exports field data, but not encrypted fields or protected stored values. Use this option to exclude sensitive data from a .czar file.

       A.czar file will never contain decrypted data, even if encrypted fields are exported. If data is provided to support, we recommend excluding encrypted fields from database exports. Encryption keys are not included in any database exports; we recommend exporting keys from the Server Manager and storing them in a secure location. See Configure Encryption Keys for a Server or Web Application.

     • Exclude emails: Select to exclude email messages.
   • Export Table Structure Only: Exports all SQL Server tables without any data. Use this option to create a .czar file that excludes confidential company data.
   • Export Structure and Lookup Table Data: Exports SQL Server tables for all Major and Supporting Business Objects, as well as tables and data for Lookup Objects (validation tables). Use this to create a .czar file that excludes confidential data but includes values from Lookup Tables (typically, Lookup Tables do not contain confidential data and can be used to troubleshoot problems with validation and relationships).
4. Follow steps 5 - 7 above.