Data Documenter not saving Descriptions

Discussion of open issues, suggestions and bugs regarding database management and development tools for SQL Server
Post Reply
Drewsonian
Posts: 15
Joined: Fri 09 Nov 2012 20:10

Data Documenter not saving Descriptions

Post by Drewsonian » Mon 07 Aug 2017 16:05

I am unable to get descriptions for tables and fields to successfully save to the ddoc file. If I save descriptions into their fields using documenter, save the file and then close the documenter and reopen it, all the descriptions disappear.

Drewsonian
Posts: 15
Joined: Fri 09 Nov 2012 20:10

Re: Data Documenter not saving Descriptions

Post by Drewsonian » Mon 07 Aug 2017 16:30

Update: Does Documenter work with Azure databases? Because I think I'm seeing that it works to save descriptions on my local databases, but doesn't work on Azure databases. Does it store the description in the database metadata? If so, I could see why Azure may not work...

Drewsonian
Posts: 15
Joined: Fri 09 Nov 2012 20:10

Re: Data Documenter not saving Descriptions

Post by Drewsonian » Mon 07 Aug 2017 17:26

Further info: When I save a description from documenter, I can see that it does save to the extended properties in the Azure SQL database using the following query:

Code: Select all

SELECT * FROM sys.extended_properties
However, when I close out of the documenter and re-open it, it appears that the documenter isn't loading the properties back into fields correctly.

Thanks!

Post Reply