The tool reads file with tabbed values: table name column name description
The file will be transformed to two SQL files for SQL Server and Oracle. The new files will contain SQL commands for adding descriptions to a table or a column
-- for tables and columns
select table_name, column_name, Description from ( select st.name [table_name], null [column_name], sep.value [Description] from sys.tables st left join sys.extended_properties sep on st.object_id = sep.major_id and sep.name = 'MS_Description' where st.schema_id = 1 and (sep.minor_id is null or sep.minor_id = 0) UNION select st.name [table_name], sc.name [column_name], sep.value [Description] from sys.tables st inner join sys.columns sc on st.object_id = sc.object_id left join sys.extended_properties sep on st.object_id = sep.major_id and sc.column_id = sep.minor_id and sep.name = 'MS_Description' where st.schema_id = 1 ) as Qu where Description is null order by table_name, column_name
-- for views
select st.name [view_name], sep.value [Description] from sys.views st left join sys.extended_properties sep on st.object_id = sep.major_id and sep.name = 'MS_Description' where sep.value is null order by st.name
--for tables and views
SELECT table_name, comments, owner
FROM all_tab_comments
where
owner = 'NETMETER'
and (comments is null or comments = '')
order by table_name
--for table columns
SELECT TABLE_NAME, COLUMN_NAME, C.COMMENTS
FROM user_col_comments C join user_tab_cols K
USING (TABLE_NAME, COLUMN_NAME)
WHERE
(C.comments is null or C.comments = '')
order by TABLE_NAME
Then the result can by copied to Excel. Descriptions should be filled and result saved to tabbed file