Export to Data Definition Language (DDL)

It never hurts to back up your work! This page describes how to export the metadata (e.g., structure, column headings, visualization attributes) associated with user-created queries, dashboard widgets and reports. The exports go to Data Definition Language (DDL) formatted files. In the event of a system failure during an upgrade, your Solutions Architect can use this file to recover the dashboard widgets and reports you created. Asset Manager recommends generating this file before upgrades, especially if you create or update dashboards or custom reports frequently. Store the backup DDL files in a safe place.

Export metadata to DDL

1. Browse to User Profile > Settings > Export.
   
2. Select a database option from the list and click Export Metadata.
   
3. Your custom dashboards and report configurations are exported to a DLL file.
4. Retain this text file for use in the event of a system failure. 

Export only user-created metadata

1. Browse to User Profile > Settings > Import/Export.

2. Click Export Metadata to export all metadata (Default and User Created) to a DDL file.

3. Click Export User Defined Metadata to export only user-created metadata to a DDL file.

4. Retain this DDL file for use in the event of a system failure.