There is now - at least one :)
Try my new LiveDoco - it's a web app that can be installed on an intranet IIS or even on a local IIS server and then you can just use your favorite browser to connect to a SQL Server database and see its structure/metadata, edit object descriptions or even search in DB object names (tables, columns, functions and their parameters etc.) and in the extended properties where the descriptions are usually stored (under “MS_Description”). And finally there is an export feature you can use to export all extended properties to a SQL file that you can run on a different DB of the same/similar structure to import/update your descriptions/notes there.
There are several advantages over the usual DB documentation process:
- Since the documentation is generated on the fly (hence Live in the product title) – it is never out of sync with your DB by definition. Any changes to the DB schema are immediately seen in LiveDoco.
- LiveDoco supports deep linking, so you can just email a link to say a column in some view your colleague is asking about.
- It only needs to be installer once on an intranet web server and is immediately available to all your devs/dbas/support etc.
There is a fully functional (but read-only for obvious reasons) online demo on the www.livedoco.com website so please have a look yourself!