Import & export descriptions and extended properties


Most database engines have capability to provide short, plain text descriptions (or comments) for tables, columns and other objects (depending on engine). Dataedo reads those comments into the documentation, lets you work on them and then push back to the database.

Extended properties

SQL Server database (and Azure SQL Database) provide unique functionality of extended properties. Extended properties are custom metadata fields you can attach to almost any schema element. This functionality corresponds with Dataedo custom fields and on top of regular comments, you can also read extended properties into custom fields and vice versa.

Just map custom fields to extended properties and there you are!