Exporting descriptions to database

21st December, 2017
Applies to: 6.x versions, Article available also for: 9.x (current), 8.x, 7.x
You are looking at documentation for an older release.
Switch to the documentation for Dataedo 9.x (current).

This feature applies only to SQL Server, Azure SQL Database, Azure SQL Data Warehouse and Oracle.

Dataedo 6 allows exporting descriptions (from Description column) back to database itself. This is implemented as a separate task under Export documentation menu.

Database support

SQL Server, Azure SQL Database, Azure SQL Data Warehouse: Yes

Oracle: Yes

MySQL, MariaDB Server: No

Amazon Aurora: No

Rich text fields

Some descriptions in Dataedo are entered in rich text format, including formatting, lists, tables, images etc. This is saved in Dataedo repository as HTML. Export function removes formatting and writes only plain text.

String length

Databases have different limitations in terms of maximum string length. Dataedo fields are longer and it is possible that descriptions exported to your database may be trucated if their lenth exceeds database capabilities.

Required permissions

SQL Server, Azure SQL Database

ALTER permissions on objects you want to add extended property to (tables, views, functions, procedures, triggers).

Oracle

COMMENT ANY TABLE privilege.

Exporting descriptions

If you want to export descriptions please choose Export documentation in the ribbon. In dialog box choose Export descriptions to database or Export comments to database, depending on the engine.

Export wizard

Click Next and provide connection details (you will see connection details you provided at import/update).

Connection details

In next step you can filter objects you want to export to specific modules.

Choose modules

Now you can filter specific object types.

Choose object types

If you're exporting descriptions to SQL Server, and you have any custom fields in your repository, you will see an additional form for exporting custom fields to extended properties.

Let's skip it for now - to find out more read Exporting custom fields to extended properties.

Choose custom fields

When ready click Export button.

Congratulations, descriptions have been saved in your database.

Export finished

Found issue with this article? Comment below
0
There are no comments. Click here to write the first comment.