Page 1 of 1
Data Documenter not saving Descriptions
Posted: Mon 07 Aug 2017 16:05
by Drewsonian
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.
Re: Data Documenter not saving Descriptions
Posted: Mon 07 Aug 2017 16:30
by Drewsonian
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...
Re: Data Documenter not saving Descriptions
Posted: Mon 07 Aug 2017 17:26
by Drewsonian
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!