SQL Doc

RickPRickP Posts: 5 Bronze 1
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?

Answers

  • Eddie DEddie D Posts: 1,660 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
    Product Support Engineer
    Redgate Software Ltd
    Email: [email protected]
  • RickPRickP Posts: 5 Bronze 1
    Thanks Eddie. Too bad. I assume I will just update the Extended Properties with SQL.
  • 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!
Sign In or Register to comment.