SQL Doc

RickPRickP Posts: 5 Bronze 1
in SQL Doc
We have hundreds of databases. Each one is basically the same but store different information for different clients.  Is there a way to use SQL Doc to document one database and then have the descriptions copied to other Database descriptions for the same table and column name?
Tagged:
· Share on Twitter

Answers

  • Eddie DEddie D Posts: 1,802 Rose Gold 5
    Hi RickP,
    Thank you for your forum post.

    Sadly the answer to your question is no.  Each database is treated a separate entity and a change in the MS_Description field in database1 is not transferable to database2 and so.

    Many Thanks
    Eddie 
    Eddie Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com
    · Share on Twitter
  • RickPRickP Posts: 5 Bronze 1
    Thanks Eddie. Too bad. I assume I will just update the Extended Properties with SQL.
    · Share on Twitter
  • Phil_FactorPhil_Factor Posts: 9 Bronze 1
    Yes, you can do it with SQL.
    It is possible to script out just the extended properties using SSMS, or by using PowerShell/SMO. These can then be executed for every database in your list. If every database has the documented objects it should work easily. It is, I think, also possible to get  SQL Compare to generate a script. for just syncing the Extended properties. In both cases,  you need to ensure that only the MS_Description properties get copied!
    · Share on Twitter
Sign In or Register to comment.