How can we help you today? How can we help you today?

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?
RickP
0

Comments

3 comments

Sort by
  • Eddie D
    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 D
    0
  • RickP
    Thanks Eddie. Too bad. I assume I will just update the Extended Properties with SQL.
    RickP
    0
  • Phil_Factor
    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!
    Phil_Factor
    0

Add comment

Please sign in to leave a comment.