Support description attribute in columns and tables #291

Closed
martinsura opened this Issue Aug 16, 2012 · 7 comments

Comments

Projects
None yet
5 participants

Is here any chance to add implementation description attribute ( maybe mssql only ) ?

We use description attributes for generating database documentation.

cupito commented Sep 25, 2012

i would appreciate this also

Contributor

daniellee commented Sep 25, 2012

This can be done with sql (using the Execute.Sql expression) by running the Sql Server-specific stored procedure sp_addextendedproperty (http://technet.microsoft.com/en-us/library/ms180047.aspx). See this answer on Stack Overflow for more details: http://stackoverflow.com/questions/3754180/adding-a-column-description

Is that good enough or do you think that FluentMigrator should support stuff like this? Pull request welcome as always ;-)

cupito commented Sep 25, 2012

Dear Daniel,

Honestly fluentmigrator should provide this, cause of this database independent approach. I do not develop for sql server. I use this for oracle and db2. So it would reduce the manual amount of manipulating.

Thx in advance.
Sebastian

Daniel Lee notifications@github.com schrieb:

This can be done with sql (using the Execute.Sql expression) by running
the Sql Server-specific stored procedure sp_addextendedproperty
(http://technet.microsoft.com/en-us/library/ms180047.aspx). See this
answer on Stack Overflow for more details:
http://stackoverflow.com/questions/3754180/adding-a-column-description

Is that good enough or do you think that FluentMigrator should support
stuff like this? Pull request welcome as always ;-)


Reply to this email directly or view it on GitHub:
schambers#291 (comment)

Diese Nachricht wurde von meinem Android-Mobiltelefon mit K-9 Mail gesendet.

Contributor

daniellee commented Sep 25, 2012

@cupito not sure I understand. Isn't this a feature for Sql Server Management Studio? How is it database independent? As it can be done very easily with the Execute.Sql expression, why should we add support for it to FluentMigrator? I feel like I'm missing something here. Are extended properties commonly used?

cupito commented Sep 25, 2012

Sorry my fault. I answered from my mobile and missed the header cause i had another open issue. But my answer is sill working.

comments are not only available in sql server. You can use comments on many dbms for documentation purpose (e.g. http://www.adp-gmbh.ch/ora/sql/comment.html, http://www.firebirdsql.org/refdocs/langrefupd25-ddl-comment.html). so if would like to support a lot of databases, it should be possible to comment a column or table.

The fluentmigrator is a great tool, just because you do not have to take care of so many issues of different databases. To add comments on a "execute.sql" way means, to get in touch with every single way of commenting and this means a disruption of the workflow, for which i "love" fluentmigrator. So yes i would appreciate a comment interface.

Contributor

daniellee commented Sep 25, 2012

Ok, thought you were proposing support for extended properties. Makes more sense now.

Contributor

dealproc commented Dec 24, 2012

any way to "upvote" this one?

tommarien closed this Dec 30, 2013

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment