I want to convert / import extended properties of table columns of a lot of tables to simple comments next to the table definition scripts columns in the table definition of a new SSDT database project in order to get rid of the extended properties in future but keep the column description information.
The usage of SSDT with source control makes the extended properties in the deployed version of the database obsolete.
So the description info of this:
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'Customer article number.', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'OrdPos', @level2type = N'COLUMN', @level2name = N'ArticleNo';
should get added to the columns definition like to this:
CREATE TABLE [dbo].[OrdPos] ( [ArticleNo] VARCHAR(10) NOT NULL -- Customer article number. ...
The Create Table scripts have already been created. The extended properties are all included in those scripts below the create table statements (as imported into the project). It is way too much to do it manually.
Did by chance anyone already have a similar task to solve with a good approach for some kind of automation?